For string columns, null will be interpreted as an empty string and for
others, it will be interpreted as null...
On Wednesday, October 16, 2013, Raj Hadoop wrote:
All,
When a query is executed like the below
select field1 from table1 where field1 is null;
I am getting the results
Thanks. It worked for me now when i use it as an empty string.
From: Krishnan K kkrishna...@gmail.com
To: user@hive.apache.org user@hive.apache.org; Raj Hadoop
hadoop...@yahoo.com
Sent: Thursday, October 17, 2013 11:11 AM
Subject: Re: Hive Query Questions
All,
When a query is executed like the below
select field1 from table1 where field1 is null;
I am getting the results which have empty values or nulls in field1. How does
is null work in Hive queries.
Thanks,
Raj