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 >
