hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lefty Leverenz (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-13146) OrcFile table property values are case sensitive
Date Tue, 01 Mar 2016 21:10:18 GMT

    [ https://issues.apache.org/jira/browse/HIVE-13146?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15174406#comment-15174406
] 

Lefty Leverenz commented on HIVE-13146:
---------------------------------------

Should this be documented in the wiki, in which case* it needs a TODOC1.3 label, or is it
just a bug fix?

*pun intended

> 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
>             Fix For: 1.3.0, 2.1.0
>
>         Attachments: HIVE-13146.1.patch, HIVE-13146.2.patch, HIVE-13146.3.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)

Mime
View raw message