[HIVE-11340] Create ORC based table using like clause doesn't copy compression property

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.14.0, 1.0.0, 1.2.0
• Fix Version/s: 2.0.0
• Component/s: File Formats
• Target Version/s: 1.3.0
• Assignee: Yongzhi Chen
• Reporter: Gaurav Kohli
• Created: 22/Jul/15 15:30
• Updated: 16/Feb/16 23:51
• Resolved: 11/Aug/15 17:01

Description

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