Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive, mail # user - Hive Query Questions - is null in WHERE


+
Raj Hadoop 2013-10-16, 14:08
+
Krishnan K 2013-10-17, 14:41
Copy link to this message
-
Re: Hive Query Questions - is null in WHERE
Raj Hadoop 2013-10-17, 18:01
 
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:

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