You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Selvaganesan Govindarajan (JIRA)" <ji...@apache.org> on 2016/05/02 00:07:12 UTC
[jira] [Assigned] (TRAFODION-1961) An empty string in HIVE
shouldn't be treated as NULL in Trafodion
[ https://issues.apache.org/jira/browse/TRAFODION-1961?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Selvaganesan Govindarajan reassigned TRAFODION-1961:
----------------------------------------------------
Assignee: Selvaganesan Govindarajan
> 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: Selvaganesan Govindarajan
>
> 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)