[HIVE-13146] OrcFile table property values are case sensitive

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.2.1
• Fix Version/s: 1.3.0, 2.1.0
• Component/s: ORC
• Assignee: Yongzhi Chen
• Reporter: Andrew Sears
• Created: 24/Feb/16 16:01
• Updated: 21/Jun/16 15:43
• Resolved: 01/Mar/16 14:48

Description

In Hive v1.2.1.2.3, with Tez , create an external table with compression SNAPPY value marked as lower case. Table is created successfully. Insert data into table fails with no enum constant error.

CREATE EXTERNAL TABLE mydb.mytable
(id int)
PARTITIONED BY (business_date date)
STORED AS ORC
LOCATION
'/data/mydb/mytable'
TBLPROPERTIES (
'orc.compress'='snappy');

set hive.exec.dynamic.partition=true;
set hive.exec.dynamic.partition.mode=nonstrict;

INSERT OVERWRITE mydb.mytable PARTITION (business_date)
SELECT * from mydb.sourcetable;

Caused by: java.lang.IllegalArgumentException: No enum constant org.apache.hadoop.hive.ql.io.orc.CompressionKind.snappy
at java.lang.Enum.valueOf(Enum.java:238)
at org.apache.hadoop.hive.ql.io.orc.CompressionKind.valueOf(CompressionKind.java:25)

Constant SNAPPY needs to be uppercase in definition to fix. Case should be agnostic or throw error on creation of table.