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

["Eugene Koifman (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-8079?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Eugene Koifman updated HIVE-8079:
---------------------------------
    Assignee:     (was: Eugene Koifman)

> 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
>
> {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)