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.swarnim@gmail.com <
kulkarni.swarnim@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/HIVE287
>
> On Tue, Aug 7, 2012 at 1:07 PM, Techy Teck <comptechgeeky@gmail.com>
> wrote:
>
> > I am running Hive 0.6.
> >
> >
> >
> >
> >
> > On Tue, Aug 7, 2012 at 11:04 AM, kulkarni.swarnim@gmail.com <
> > kulkarni.swarnim@gmail.com> wrote:
> >
> >> What is the hive version that you are using?
> >>
> >>
> >> On Tue, Aug 7, 2012 at 12:57 PM, Techy Teck <comptechgeeky@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 <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?
> >>> > >
> >>> > >
> >>> > >
> >>> > >
> >>> >
> >>>
> >>
> >>
> >>
> >> 
> >> Swarnim
> >>
> >
> >
>
>
> 
> Swarnim
>
