Thanks. It worked for me now when i use it as an empty string.
From: Krishnan K <[EMAIL PROTECTED]>
To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>; Raj Hadoop <[EMAIL PROTECTED]>
Sent: Thursday, October 17, 2013 11:11 AM
Subject: Re: Hive Query Questions - is null in WHERE
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:
>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.