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

["Yongzhi Chen (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-13146?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Yongzhi Chen reassigned HIVE-13146:
-----------------------------------

    Assignee: Yongzhi Chen

> 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
>            Assignee: Yongzhi Chen
>            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)