You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Qifan Chen (JIRA)" <ji...@apache.org> on 2015/10/29 16:16:27 UTC
[jira] [Created] (TRAFODION-1568) Need to create a partitioned
salted table with the CREATE TABLE LIKE cause even though the source table
is not partitioned.
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)