[
https://issues.apache.org/jira/browse/TRAFODION-1961?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15273435#comment-15273435
]
liu ming commented on TRAFODION-1961:
-------------------------------------
Hi, Selva,
What empty string means here?
If a text data file delimited with '|' and have 3 columns:
a|b|c
a||c
the first will have ('a'), ('b'), ('c')
the second row will have ('a'), null, ('c')
I feel this is normal?
thanks,
Ming
> 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)
