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

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


Copy link to this message
-
Hive Query Questions - is null in WHERE
Raj Hadoop 2013-10-16, 14:08
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