[
https://issues.apache.org/jira/browse/TRAFODION-2044?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
David Wayne Birdsall resolved TRAFODION-2044.
---------------------------------------------
Resolution: Fixed
> CREATE TABLE LIKE with SALT USING clause uses source table partition count
> ---------------------------------------------------------------------------
>
> Key: TRAFODION-2044
> URL: https://issues.apache.org/jira/browse/TRAFODION-2044
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmu
> Affects Versions: 2.0-incubating
> Environment: Trafodion 2.0 environment
> Reporter: Carol Pearson
> Assignee: David Wayne Birdsall
> Fix For: 2.1-incubating
>
>
> Using CREATE TABLE LIKE to create a table, then changing the number of
> partitions. The resulting new table number of partitions matches the
> partitioncount for the source table in the CREATE TABLE LIKE statement,
> rather than the value specified in the command:
> See the following commands:
> >>>create table tsource (c1 int not null, c2 int not null, primary key (c1))
> +>salt using 4 partitions;
> --- SQL operation complete.
> >>create table tsource_like like tsource salt using 8 partitions;
> --- SQL operation complete.
> >>showddl tsource_like
> +>;
> CREATE TABLE TRAFODION.SEABASE.TSOURCE_LIKE
> (
> C1 INT NO DEFAULT NOT NULL NOT DROPPABLE
> SERIALIZED
> , C2 INT NO DEFAULT NOT NULL NOT DROPPABLE
> SERIALIZED
> , PRIMARY KEY (C1 ASC)
> )
> SALT USING 4 PARTITIONS
> ;
> --- SQL operation complete.
> >>
> But table tsource_like was created using SALT USING 8 PARTITIONS
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
