In that case you might want to try "count(1)" instead of "count(*)" and see if that makes any difference. [1]
[1] https://issues.apache.org/jira/browse/HIVE-287 On Tue, Aug 7, 2012 at 1:07 PM, Techy Teck <comptechge...@gmail.com> wrote: > I am running Hive 0.6. > > > > > > On Tue, Aug 7, 2012 at 11:04 AM, kulkarni.swar...@gmail.com < > kulkarni.swar...@gmail.com> wrote: > >> What is the hive version that you are using? >> >> >> On Tue, Aug 7, 2012 at 12:57 PM, Techy Teck <comptechge...@gmail.com>wrote: >> >>> I am not sure about the data, but when we do >>> >>> SELECT count(*) from data_realtime where dt='20120730' and uid is null >>> >>> I get the count >>> >>> but If I do- >>> >>> SELECT * from data_realtime where dt='20120730' and uid is null >>> >>> I get zero record back. But if all the record is NULL then I should be >>> getting NULL record back right? >>> >>> >>> But I am not getting anything back and that is the reason it is making me >>> more confuse. >>> >>> >>> >>> >>> >>> >>> On Tue, Aug 7, 2012 at 10:31 AM, Yue Guan <pipeha...@gmail.com> wrote: >>> >>> > Just in case, all Record is null when uid is null? >>> > >>> > On Tue, Aug 7, 2012 at 1:14 PM, Techy Teck <comptechge...@gmail.com> >>> > wrote: >>> > > 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? >>> > > >>> > > >>> > > >>> > > >>> > >>> >> >> >> >> -- >> Swarnim >> > > -- Swarnim