I would just do a query that produces multiple outputs or select that data into a table and roll that up.
On Thursday, July 26, 2012, Bejoy Ks <[email protected]> wrote: > 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 <[email protected]> > To: [email protected] > 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. > > > > >
