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
