Let me try that and I will update on this thread If I found something interesting.
Thanks for the help kulkarni. On Tue, Aug 7, 2012 at 11:10 AM, kulkarni.swar...@gmail.com < kulkarni.swar...@gmail.com> wrote: > 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 >