You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Raj Hadoop <ha...@yahoo.com> on 2013/10/16 16:08:29 UTC

Hive Query Questions - is null in WHERE

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

Re: Hive Query Questions - is null in WHERE

Posted by Raj Hadoop <ha...@yahoo.com>.

Thanks. It worked for me now when i use it as an empty string.

________________________________
From: Krishnan K <kk...@gmail.com>
To: "user@hive.apache.org" <us...@hive.apache.org>; Raj Hadoop <ha...@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

Re: Hive Query Questions - is null in WHERE

Posted by Krishnan K <kk...@gmail.com>.

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
>