[ https://issues.apache.org/jira/browse/TRAFODION-1961?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anoop Sharma resolved TRAFODION-1961. ------------------------------------- Resolution: Fixed Fix Version/s: 2.1-incubating > An empty string in HIVE shouldn't be treated as NULL in Trafodion > ------------------------------------------------------------------ > > Key: TRAFODION-1961 > URL: https://issues.apache.org/jira/browse/TRAFODION-1961 > Project: Apache Trafodion > Issue Type: Bug > Reporter: Selvaganesan Govindarajan > Assignee: Anoop Sharma > Fix For: 2.1-incubating > > > Hive table select > hive> select * from nulls ; > OK > nulls.a nulls.b > NULL a > NULL a > aaa1 bbbbb1 > bbbbb2 > aaa3 > aaa5 > bbbbb6 > When this table is accessed from Trafodion, the empty string is treated as > NULL > >>cqd hive_max_string_length '10' ; > --- SQL operation complete. > >>fc sele > >>select * from hive.hive.nulls ; > .. > A B > ---------- ---------- > ? a > ? a > aaa1 bbbbb1 > ? bbbbb2 > aaa3 ? > ? ? > aaa5 ? > ? bbbbb6 > Need a CQD to provide backward compatibility with the old behavior. -- This message was sent by Atlassian JIRA (v6.3.4#6332)