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


Copy link to this message
-
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
+
Krishnan K 2013-10-17, 14:41
+
Raj Hadoop 2013-10-17, 18:01