hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bejoy Ks <bejoy...@yahoo.com>
Subject Re: Group By with rollup in HiveQL?
Date Thu, 26 Jul 2012 13:59:05 GMT
Hi

At the moment Hive QL doesn't support rollup clause, however the development is in progress
for this feature.

https://issues.apache.org/jira/browse/HIVE-2397 


Regards
Bejoy KS



________________________________
 From: Techy Teck <comptechgeeky@gmail.com>
To: user@hive.apache.org 
Sent: Thursday, July 26, 2012 9:28 AM
Subject: Group By with rollup in HiveQL?
 

select id2, 
SUM(count2),SUM(coalesce(count1, 0)) as count1  
from table2  
 left outer join
table1  
  on id1=id2 
 group by id2 
 with rollup 
 
Whenever I am trying to run the above query, I am getting
always as `FAILED: Parse Error: line  mismatched input 'with' expecting EOF`.
So
that means I cannot use rollup in HiveQL?
I am running Hive 0.6.
Mime
View raw message