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 <comptechge...@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.
