Re: Group By with rollup in HiveQL?

[Techy Teck]

> *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.
>
>
>
>
>