Anoop Sharma created TRAFODION-2072: ---------------------------------------
Summary: long char columns cause non-deterministic behavior Key: TRAFODION-2072 URL: https://issues.apache.org/jira/browse/TRAFODION-2072 Project: Apache Trafodion Issue Type: Bug Reporter: Anoop Sharma Assignee: Anoop Sharma 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; -- This message was sent by Atlassian JIRA (v6.3.4#6332)