Qifan Chen created TRAFODION-1568: ------------------------------------- Summary: Need to create a partitioned salted table with the CREATE TABLE LIKE cause 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)