You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Atanu Mishra (JIRA)" <ji...@apache.org> on 2015/08/14 01:40:46 UTC
[jira] [Closed] (TRAFODION-139) LP Bug: 1246449 - SALT ... ON
(,...) returns ERROR 1009 for non-clustering key columns while the
table is still created
[ https://issues.apache.org/jira/browse/TRAFODION-139?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Atanu Mishra closed TRAFODION-139.
----------------------------------
Resolution: Fixed
Assignee: (was: Hans Zeller)
Fix Version/s: 1.0 (pre-incubation)
> LP Bug: 1246449 - SALT ... ON (<col>,...) returns ERROR 1009 for non-clustering key columns while the table is still created
> ----------------------------------------------------------------------------------------------------------------------------
>
> Key: TRAFODION-139
> URL: https://issues.apache.org/jira/browse/TRAFODION-139
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-general
> Reporter: Weishiun Tsai
> Priority: Critical
> Fix For: 1.0 (pre-incubation)
>
>
> When creating a table using SALT … ON (<col>, <col>, ). It returns 1009 “column does not exist in the table error” whenever any of the column is not a clustering key. Furthermore, the table is still being created even after the statement returns the error, as shown in the following example:
> >>create table t (a int not null not droppable, b int not null not droppable, c
> int not null not droppable) store by (a, b, c) salt using 4 partitions on (a, b,
> c);
> --- SQL operation complete.
> >>drop table t;
> --- SQL operation complete.
> >>create table t (a int not null not droppable, b int, c int) store by (a) salt
> using 4 partitions on (a, b, c);
> *** ERROR[1009] Column B does not exist in the specified table.
> *** ERROR[1009] Column C does not exist in the specified table.
> --- SQL operation failed with errors.
> >>showddl t;
> CREATE TABLE SEABASE.SEABASE.T
> (
> A INT NO DEFAULT NOT NULL NOT DROPPABLE
> , B INT DEFAULT NULL
> , C INT DEFAULT NULL
> )
> STORE BY (A ASC)
> ;
> --- SQL operation complete.
> >>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)