hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Techy Teck <comptechge...@gmail.com>
Subject Re: Group By with rollup in HiveQL?
Date Thu, 26 Jul 2012 04:59:14 GMT
> *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.
>
>
>
>
>

Mime
View raw message