[
https://issues.apache.org/jira/browse/HIVE-20092?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16534680#comment-16534680
]
runlin commented on HIVE-20092:
-------------------------------
you can use this " CREATE TABLE empty_key_value_store
LIKE key_value_store [TBLPROPERTIES ('COMMENT'=property_value)]; "
eg:CREATE TABLE `test_like` LIKE `test` STORED AS ORC
TBLPROPERTIES('orc.compress'='SNAPPY',COMMENT 'test_like' );
> Hive create table like comment
> ------------------------------
>
> Key: HIVE-20092
> URL: https://issues.apache.org/jira/browse/HIVE-20092
> Project: Hive
> Issue Type: Bug
> Components: SQL
> Affects Versions: 1.1.0
> Reporter: wxmimperio
> Assignee: runlin
> Priority: Major
> Attachments: image-2018-07-05-14-05-59-644.png
>
>
> In cloudera:
> *Cloning tables (LIKE clause):*
> !image-2018-07-05-14-05-59-644.png!
> [https://www.cloudera.com/documentation/enterprise/5-8-x/topics/impala_create_table.html]
> However can not run：
>
> {code:java}
> hive> CREATE TABLE `test_like` LIKE `test` COMMENT 'test_like' STORED AS ORC
> TBLPROPERTIES('orc.compress'='SNAPPY');
> FAILED: ParseException line 1:38 missing EOF at 'COMMENT' near 'test'
> {code}
>
> Can I add COMMIT in sql if I create table like?
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
