hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Raj Hadoop <hadoop...@yahoo.com>
Subject Re: Hive Query Questions - is null in WHERE
Date Thu, 17 Oct 2013 18:01:34 GMT
 
Thanks. It worked for me now when i use it as an empty string.


________________________________
From: Krishnan K <kkrishnan88@gmail.com>
To: "user@hive.apache.org" <user@hive.apache.org>; Raj Hadoop <hadoopraj@yahoo.com>

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:

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
Mime
View raw message