[
https://issues.apache.org/jira/browse/HIVE-11340?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14662232#comment-14662232
]
Yongzhi Chen commented on HIVE-11340:
-------------------------------------
Change the test to use describe formatted.
It seems that in order not to be masked by the output, the property has to be
explicitly used. Add get compress info in the OrcSerde initialize method. Also
fix a bug in OrcConf.
> 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
> Affects Versions: 0.14.0, 1.0.0, 1.2.0
> Reporter: Gaurav Kohli
> Assignee: Yongzhi Chen
> Priority: Minor
> Attachments: HIVE-11340.1.patch
>
>
> 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 :
> {code}
> create table orc_table (
> time string)
> stored as ORC tblproperties ("orc.compress"="SNAPPY");
> {code}
> Step 2:
> {code}
> create table orc_table_using_like like orc_table;
> {code}
> Step 3:
> {code}
> show create table orc_table_using_like;
> {code}
> Result:
> {code}
> 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')
> {code}
> Issue: 'orc.compress'='SNAPPY' property is missing
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
