You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Yongzhi Chen (JIRA)" <ji...@apache.org> on 2016/02/25 19:06:18 UTC
[jira] [Updated] (HIVE-13146) OrcFile table property values are
case sensitive
[ https://issues.apache.org/jira/browse/HIVE-13146?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yongzhi Chen updated HIVE-13146:
--------------------------------
Status: Patch Available (was: Open)
> 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
>
>
> 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)