Re: what char represents NULL value in hive?

[Bennie Schut <bs...@ebuddy.com>]

At least on trunk it seems on external tables(perhaps also TextFile?) 
this works for integer values but not for string values. For a string it 
will then return as an empty string which you then have to find with " 
where field = '' " but I would prefer to use " where field is null ".
Not sure if this should be filed as a bug or a missing feature ;-)
Perhaps there is a relation with HIVE-1791?

On 01/21/2011 02:03 PM, Ajo Fod wrote:
> For a tab separated file, I think it is the null string ... i.e no
> characters. So, for example
>
> 12\ta\t\t2
> 1\tb\ta\t1
>
> reads
> 12     a<NULL>       2
> 1        b      a              1
>
> On Fri, Jan 21, 2011 at 1:09 AM, lei liu<li...@gmail.com>  wrote:
>> I generate HDFS file , then I load the file to one hive table. There are
>> some colums are don't have value, I need to set these colums to NULL.   I
>> want to know what char represents NULL value in hive.
>>
>>
>> Thanks,
>>
>> LiuLei
>>
>>
>>