Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB