[jira] [Closed] (TRAFODION-196) LP Bug: 1291534 - Select returns internal error at HASH2PARTFUNC() on a salted table with no primary/clustering key

["Atanu Mishra (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-196?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Atanu Mishra closed TRAFODION-196.
----------------------------------
       Resolution: Fixed
         Assignee:     (was: Hans Zeller)
    Fix Version/s: 1.0 (pre-incubation)

> LP Bug: 1291534 - Select returns internal error at HASH2PARTFUNC() on a salted table with no primary/clustering key
> -------------------------------------------------------------------------------------------------------------------
>
>                 Key: TRAFODION-196
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-196
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-cmp
>            Reporter: Weishiun Tsai
>            Priority: Critical
>             Fix For: 1.0 (pre-incubation)
>
>
> Currently in Trofodion, a user can create a table without explicitly specifying any primary key or clustering key.  But if the user creates a salted table this way, the table is unusable.  Select statement returns internal error at HASH2PARTFUNC().
> This is seen on the datalake build v38180 installed on the cluster rhel-cdh1. 
> The 1st part of the following output shows the error.  The 2nd, 3rd, and 4th parts show that when the table is created with a primary key, a clustering key, or unsalted, the select statement runs fine.
> SQL>create table t (a int not null) salt using 2 partitions;
> --- SQL operation complete.
> SQL>select * from t;
> *** ERROR[15001] A syntax error occurred at or before:
> HASH2PARTFUNC( FOR 2);
>                   ^ (19 characters from start of SQL statement) [2014-03-12 11:05:54]
> *** ERROR[2006] Internal error: assertion failure (vdesc) in file ../optimizer/ValueDesc.cpp at line 98. [2014-03-12 11:05:54]
> SQL>drop table t;
> --- SQL operation complete.
> SQL>create table t (a int not null primary key) salt using 2 partitions;
> --- SQL operation complete.
> SQL>select * from t;
> --- 0 row(s) selected.
> SQL>drop table t;
> --- SQL operation complete.
> SQL>create table t (a int not null) store by (a) salt using 2 partitions;
> --- SQL operation complete.
> SQL>select * from t;
> --- 0 row(s) selected.
> SQL>drop table t;
> --- SQL operation complete.
> SQL>create table t (a int not null);
> --- SQL operation complete.
> SQL>select * from t;
> --- 0 row(s) selected.
> SQL>drop table t;
> --- SQL operation complete.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)