hive-user 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 18:07:08 GMT
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
>

Mime
View raw message