Major 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.
>>
Attachments
Issue Links
- links to
