You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Eugene Koifman (JIRA)" <ji...@apache.org> on 2014/09/12 21:30:33 UTC

[jira] [Created] (HIVE-8079) CTAS_PARCOL_COEXISTENCE should mention bucketing

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)