hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Techy Teck <comptechge...@gmail.com>
Subject Re: Some Weird Behavior
Date Tue, 07 Aug 2012 17:57:29 GMT
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 <pipehappy@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 <comptechgeeky@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?
> >
> >
> >
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message