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<[email protected]> 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
