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
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 comptechge...@gmail.comwrote:
I am not sure about the data, but when we do
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 comptechge...@gmail.com wrote:
I am running Hive 0.6.
On Tue, Aug 7, 2012 at 11:04 AM,
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 that
