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

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: sql-cmu
• Assignee: Weiqing Xu
• Reporter: Qifan Chen
• Created: 29/Oct/15 15:16
• Updated: 12/Jun/16 10:28

Description

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