[jira] [Created] (HIVE-13146) OrcFile table property values are case sensitive

["Andrew Sears (JIRA)" <ji...@apache.org>]

Andrew Sears created HIVE-13146:
-----------------------------------

             Summary: OrcFile table property values are case sensitive
                 Key: HIVE-13146
                 URL: https://issues.apache.org/jira/browse/HIVE-13146
             Project: Hive
          Issue Type: Bug
          Components: ORC
    Affects Versions: 1.2.1
            Reporter: Andrew Sears
            Priority: Minor


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.




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)