-Re: Group By with rollup in HiveQL?
Edward Capriolo 2012-07-26, 15:05
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:
> At the moment Hive QL doesn't support rollup clause, however the
development is in progress for this feature.
> 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.