You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Techy Teck <co...@gmail.com> on 2012/08/07 19:14:23 UTC
Some Weird Behavior
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?
Re: Some Weird Behavior
Posted by Techy Teck <co...@gmail.com>.
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/HIVE-287
>
> On Tue, Aug 7, 2012 at 1:07 PM, Techy Teck <co...@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 <pi...@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 <co...@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
>
Re: Some Weird Behavior
Posted by Techy Teck <co...@gmail.com>.
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/HIVE-287
>
> On Tue, Aug 7, 2012 at 1:07 PM, Techy Teck <co...@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 <pi...@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 <co...@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
>
Re: Some Weird Behavior
Posted by "kulkarni.swarnim@gmail.com" <ku...@gmail.com>.
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 <co...@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 <co...@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 <pi...@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 <co...@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
Re: Some Weird Behavior
Posted by "kulkarni.swarnim@gmail.com" <ku...@gmail.com>.
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 <co...@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 <co...@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 <pi...@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 <co...@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
Re: Some Weird Behavior
Posted by Techy Teck <co...@gmail.com>.
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 <co...@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 <pi...@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 <co...@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
>
Re: Some Weird Behavior
Posted by Techy Teck <co...@gmail.com>.
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 <co...@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 <pi...@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 <co...@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
>
Re: Some Weird Behavior
Posted by "kulkarni.swarnim@gmail.com" <ku...@gmail.com>.
What is the hive version that you are using?
On Tue, Aug 7, 2012 at 12:57 PM, Techy Teck <co...@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 <pi...@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 <co...@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
Re: Some Weird Behavior
Posted by "kulkarni.swarnim@gmail.com" <ku...@gmail.com>.
What is the hive version that you are using?
On Tue, Aug 7, 2012 at 12:57 PM, Techy Teck <co...@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 <pi...@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 <co...@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
Re: Some Weird Behavior
Posted by Techy Teck <co...@gmail.com>.
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 <pi...@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 <co...@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?
> >
> >
> >
> >
>
Re: Some Weird Behavior
Posted by Techy Teck <co...@gmail.com>.
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 <pi...@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 <co...@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?
> >
> >
> >
> >
>
Re: Some Weird Behavior
Posted by Yue Guan <pi...@gmail.com>.
Just in case, all Record is null when uid is null?
On Tue, Aug 7, 2012 at 1:14 PM, Techy Teck <co...@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?
>
>
>
>