hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Yue Guan <pipeha...@gmail.com>
Subject Re: Some Weird Behavior
Date Tue, 07 Aug 2012 17:31:50 GMT
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
View raw message