Thanks Bejoy !
It worked.
Sent from my iPhone
On Dec 4, 2011, at 3:10 AM, Bejoy Ks wrote:
> Hi JJ
>The error message you are seeing now is because of your usage of
> groupby. You need to specify it as 'group by' , a space between group and by.
> Even if you specify it as 'group by' th
Hi folks,
Can we get a shared license key for yourkit and use it with Hive project?
The wiki page has no information about this. Can any dev help me in this
regard?
Thanks,
jS
My answer would have been a subquery but temporary view sounds much better.
Thanks for sharing, Bejoy!
- Original Message -
From: "Bejoy Ks"
To: user@hive.apache.org
Sent: Sunday, 4 December, 2011 6:10:10 AM
Subject: Re: hive case and group-by statement
Hi JJ
The error message you ar
Hi JJ
The error message you are seeing now is because of your usage of
groupby. You need to specify it as 'group by' , a space between group and by.
Even if you specify it as 'group by' the query wont execute because of a
limitation with GROUP BY in hive. It would give some parse error as
Hi,
I have a following smaple query:
select
A,
CASE
WHEN B IN(1,2) THEN 'Type A'
ELSE 'Type B'
END AS B,
C
from table_a
groupby
A, B, C;
But when i run this query, it gives error:
FAILED: Error in semantic analysis: Line 95:0 Invalid table alias or column
reference entity
This error is from B
