Gaurav Kohli created HIVE-11340:
-----------------------------------

             Summary: Create ORC based table using like clause doesn't copy 
compression property
                 Key: HIVE-11340
                 URL: https://issues.apache.org/jira/browse/HIVE-11340
             Project: Hive
          Issue Type: Bug
          Components: File Formats
            Reporter: Gaurav Kohli


I found a issue in “create table like” clause, as it is not copying the table 
properties from ORC File format based table.

Steps to reproduce:
Step1 :
create table orc_table (
time string)
stored as ORC tblproperties ("orc.compress"="SNAPPY");

Step 2: 
create table orc_table_using_like like orc_table;

Step 3:
show create table orc_table_using_like;  
Result:

createtab_stmt
CREATE TABLE `orc_table_using_like`(
  `time` string)
ROW FORMAT SERDE 
  'org.apache.hadoop.hive.ql.io.orc.OrcSerde' 
STORED AS INPUTFORMAT 
  'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat' 
OUTPUTFORMAT 
  'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'
LOCATION
  'hdfs://nameservice1/user/hive/warehouse/gkohli.db/orc_table_using_like'
TBLPROPERTIES (
  'transient_lastDdlTime'='1437578939')

Issue:  'orc.compress'='SNAPPY' property is missing






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to