You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "David Wayne Birdsall (JIRA)" <ji...@apache.org> on 2017/11/27 17:09:00 UTC
[jira] [Updated] (TRAFODION-2819) Drop table fails with error 4247
when certain CQDs are set
[ https://issues.apache.org/jira/browse/TRAFODION-2819?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Wayne Birdsall updated TRAFODION-2819:
--------------------------------------------
Description:
Drop table fails with error 4247 in the following scenario:
>>cqd HIVE_MAX_STRING_LENGTH_IN_BYTES '200';
--- SQL operation complete.
>>cqd TRAF_MAX_CHARACTER_COL_LENGTH '200';
--- SQL operation complete.
>>
>>create table my_traf_line (
+>l_orderkey int not null not droppable,
+>l_partkey int not null not droppable,
+>l_suppkey int not null not droppable,
+>l_linenumber int not null not droppable,
+>l_quantity numeric(12,2) not null not droppable,
+>l_extendedprice numeric(12,2) not null not droppable,
+>l_discount numeric(12,2) not null not droppable,
+>l_tax numeric(12,2) not null not droppable,
+>l_returnflag char(1) not null not droppable,
+>l_linestatus char(1) not null not droppable,
+>l_shipdate date not null not droppable,
+>l_commitdate date not null not droppable,
+>l_receiptdate date not null not droppable,
+>l_shipinstruct char(25) not null not droppable,
+>l_shipmode char(10) not null not droppable,
+>l_comment varchar(44) not null not droppable,
+>primary key (l_shipdate asc, l_orderkey asc, l_linenumber asc) not droppable)
+>salt using 8 partitions;
--- SQL operation complete.
>>
>>drop table my_traf_line cascade;
*** ERROR[4247] Specified size in bytes (500) exceeds the maximum size allowed (200) for column LOW_VALUE.
*** ERROR[4082] Object TRAFODION.SCH.SB_HISTOGRAMS does not exist or is inaccessible.
*** ERROR[8822] The statement was not prepared.
--- SQL operation failed with errors.
>>
> Drop table fails with error 4247 when certain CQDs are set
> ----------------------------------------------------------
>
> Key: TRAFODION-2819
> URL: https://issues.apache.org/jira/browse/TRAFODION-2819
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 2.3-incubating
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
>
> Drop table fails with error 4247 in the following scenario:
> >>cqd HIVE_MAX_STRING_LENGTH_IN_BYTES '200';
> --- SQL operation complete.
> >>cqd TRAF_MAX_CHARACTER_COL_LENGTH '200';
> --- SQL operation complete.
> >>
> >>create table my_traf_line (
> +>l_orderkey int not null not droppable,
> +>l_partkey int not null not droppable,
> +>l_suppkey int not null not droppable,
> +>l_linenumber int not null not droppable,
> +>l_quantity numeric(12,2) not null not droppable,
> +>l_extendedprice numeric(12,2) not null not droppable,
> +>l_discount numeric(12,2) not null not droppable,
> +>l_tax numeric(12,2) not null not droppable,
> +>l_returnflag char(1) not null not droppable,
> +>l_linestatus char(1) not null not droppable,
> +>l_shipdate date not null not droppable,
> +>l_commitdate date not null not droppable,
> +>l_receiptdate date not null not droppable,
> +>l_shipinstruct char(25) not null not droppable,
> +>l_shipmode char(10) not null not droppable,
> +>l_comment varchar(44) not null not droppable,
> +>primary key (l_shipdate asc, l_orderkey asc, l_linenumber asc) not droppable)
> +>salt using 8 partitions;
> --- SQL operation complete.
> >>
> >>drop table my_traf_line cascade;
> *** ERROR[4247] Specified size in bytes (500) exceeds the maximum size allowed (200) for column LOW_VALUE.
> *** ERROR[4082] Object TRAFODION.SCH.SB_HISTOGRAMS does not exist or is inaccessible.
> *** ERROR[8822] The statement was not prepared.
> --- SQL operation failed with errors.
> >>
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)