Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
Description
If a table has char/varchar columns that are more than 32K,
they show non-deterministic behavior.
This may show up for hbase format, aligned format or hive
tables.
Sometimes columns are truncated at 2-byte boundary,
sometimes large columns may cause hangs or other issues.
In the example below, the select hangs:
>>cqd traf_max_character_col_length '1000000';
— SQL operation complete.
>>create table tlvc2 (z int, b char(10), c varchar(100000), a varchar(1000000))
+> attribute aligned format;
— SQL operation complete.
>>
>>insert into tlvc2 values (1, 'abc', repeat('a', 100000), repeat ('b', 100000));
— 1 row(s) inserted.
>>
>>select char_length(a) from tlvc2;
Attachments
Issue Links
- links to
