[
https://issues.apache.org/jira/browse/HIVE-13146?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15171932#comment-15171932
]
Yongzhi Chen commented on HIVE-13146:
-------------------------------------
The tests failures for patch2 are not related.
> 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
> Attachments: HIVE-13146.1.patch, HIVE-13146.2.patch
>
>
> 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)
