[jira] [Updated] (TRAFODION-1568) Need to create a partitioned salted table with the CREATE TABLE LIKE DDL even though the source table is not partitioned.

["Qifan Chen (JIRA)" <ji...@apache.org>]

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

Qifan Chen updated TRAFODION-1568:
----------------------------------
    Summary: Need to create a partitioned salted table with the CREATE TABLE LIKE DDL even though the source table is not partitioned.    (was: Need to create a partitioned salted table with the CREATE TABLE LIKE cause even though the source table is not partitioned.  )

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