hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Techy Teck <comptechge...@gmail.com>
Subject Some Weird Behavior
Date Tue, 07 Aug 2012 17:14:23 GMT
SELECT count(*) from data_realtime where dt='20120730' and uid is null



I get the count as *1509*



So that means If I will be doing



SELECT * from data_realtime where dt='20120730' and uid is null



I should be seeing those records in which uid is null? right?

But I get zero record back with the above query. Why is it so? Its very
strange and why is it happening like this. Something wrong with the Hive?



Can anyone suggest me what is happening?

Mime
View raw message