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)