[
https://issues.apache.org/jira/browse/HIVE-20092?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
wxmimperio updated HIVE-20092:
------------------------------
Description:
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?
was:
In cloudera:
*Cloning tables (LIKE clause):*
*!image-2018-07-05-14-01-56-160.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?
> 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
> 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)
