Eugene Koifman created HIVE-8079:
------------------------------------

             Summary: CTAS_PARCOL_COEXISTENCE should mention bucketing
                 Key: HIVE-8079
                 URL: https://issues.apache.org/jira/browse/HIVE-8079
             Project: Hive
          Issue Type: Bug
          Components: SQL
    Affects Versions: 0.13.1
            Reporter: Eugene Koifman
            Assignee: Eugene Koifman


create table FOO clustered by (i) into 8 buckets stored as orc AS select * from 
BAR;

this statement throws a SemanticException with 
ErrorMsg.CTAS_PARCOL_COEXISTENCE.  The actual message text is 
"CREATE-TABLE-AS-SELECT does not support partitioning in the target table" 
which is confusing since target table is not partitioned.

The real issue is that bucketed table is not supported 
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-CreateTableAsSelect(CTAS)

Need to update the message



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to