hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew Sears (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-13146) OrcFile table property values are case sensitive
Date Wed, 24 Feb 2016 16:02:18 GMT
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)

Mime
View raw message