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.swar...@gmail.com <
kulkarni.swar...@gmail.com> wrote:
> In that case you might want to try "count(1)" instead of "count(*)" and see
> if t
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 wrote:
> I am running Hive 0.6.
>
>
>
>
>
> On Tue, Aug 7, 2012 at 11:04 AM, kulkarni.swar.
I am running Hive 0.6.
On Tue, Aug 7, 2012 at 11:04 AM, kulkarni.swar...@gmail.com <
kulkarni.swar...@gmail.com> wrote:
> What is the hive version that you are using?
>
>
> On Tue, Aug 7, 2012 at 12:57 PM, Techy Teck wrote:
>
>> I am not sure about the data, but when we do
>>
>> SELECT count(
What is the hive version that you are using?
On Tue, Aug 7, 2012 at 12:57 PM, Techy Teck 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=
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 r
Just in case, all Record is null when uid is null?
On Tue, Aug 7, 2012 at 1:14 PM, Techy Teck 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='2012
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 wit
