[
https://issues.apache.org/jira/browse/TRAFODION-1568?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jian Jin updated TRAFODION-1568:
--------------------------------
Assignee: Weiqing Xu (was: David Wayne Birdsall)
> Need to create a partitioned salted table with the CREATE TABLE LIKE DDL even
> though the source table is not partitioned.
> ---------------------------------------------------------------------------------------------------------------------------
>
> Key: TRAFODION-1568
> URL: https://issues.apache.org/jira/browse/TRAFODION-1568
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmu
> Reporter: Qifan Chen
> Assignee: Weiqing Xu
>
> When update stats for a native Hive table, the native table can be
> non-partitioned as far as Trafodion is concerned. Due to the data size of
> the sampling, it is important to have the capability to create a partitioned
> salted table with the CREATE TABLE LIKE cause even though the source table is
> not partitioned, with the syntax similar to the following.
> CREATE TABLE TRAFODION."_HIVESTATS_".SAMPLE_TABLE
> LIKE TRAFODION."_HV_HIVE_".CUSTOMER
> salt using 5 partitions on( C_CUSTOMER_SK,C_CUSTOMER_ID );
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
