hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rishabh Bhardwaj <rbnex...@yahoo.com>
Subject BIGINT NULL Value Not Returning any rows
Date Thu, 27 Mar 2014 06:28:15 GMT
Hi all,
I have a table 'tabname' which has a field 'deleteDate' with type BIGINT.There are records
with NULL value in this field.I want to retrieve all those records.
But when I execute Query,
select * from tabName where deleteDate<>NULL;

I  don't get any record in the result set.
What is wrong in this query and what should it be to serve the purpose?


Help!

Thanks,
Rishabh.

Mime
View raw message