hive-user mailing list archives

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

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

Bejoy KS

 From: Techy Teck <>
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
  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`.
that means I cannot use rollup in HiveQL?
I am running Hive 0.6.
View raw message