[ https://issues.apache.org/jira/browse/HIVE-8079?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Eugene Koifman updated HIVE-8079: --------------------------------- Description: {noformat} create table FOO clustered by (i) into 8 buckets stored as orc AS select * from BAR; {noformat} 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 was: 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 > 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 > > {noformat} > create table FOO clustered by (i) into 8 buckets stored as orc AS select * > from BAR; > {noformat} > 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)