Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Group By with rollup in HiveQL?


Copy link to this message
-
Re: Group By with rollup in HiveQL?
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.
>
>
>
>
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB