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