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