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?

Just in case, all Record is null when uid is null?

On Tue, Aug 7, 2012 at 1:14 PM, Techy Teck <[EMAIL PROTECTED]> 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?
>
>
>
>

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 <[EMAIL PROTECTED]> wrote:

> Just in case, all Record is null when uid is null?
>
> On Tue, Aug 7, 2012 at 1:14 PM, Techy Teck <[EMAIL PROTECTED]>
> 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?
> >
> >
> >
> >
>

What is the hive version that you are using?

On Tue, Aug 7, 2012 at 12:57 PM, Techy Teck <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> wrote:
>
> > Just in case, all Record is null when uid is null?
> >
> > On Tue, Aug 7, 2012 at 1:14 PM, Techy Teck <[EMAIL PROTECTED]>
> > 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