[jira] [Commented] (TRAFODION-1961) An empty string in HIVE shouldn't be treated as NULL in Trafodion

["liu ming (JIRA)" <ji...@apache.org>]

    [ 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)