You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Ashutosh Chauhan (JIRA)" <ji...@apache.org> on 2013/01/14 01:18:12 UTC
[jira] [Updated] (HIVE-2397) Support with rollup option for group
by
[ https://issues.apache.org/jira/browse/HIVE-2397?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashutosh Chauhan updated HIVE-2397:
-----------------------------------
Fix Version/s: 0.10.0
> Support with rollup option for group by
> ---------------------------------------
>
> Key: HIVE-2397
> URL: https://issues.apache.org/jira/browse/HIVE-2397
> Project: Hive
> Issue Type: New Feature
> Reporter: Kevin Wilfong
> Assignee: Namit Jain
> Fix For: 0.10.0
>
> Attachments: HIVE-2397.2.patch.txt, HIVE-2397.3.patch.txt, HIVE-2397.4.patch.txt, HIVE-2397.5.patch.txt
>
>
> We should support the ROLLUP operator similar to the way MySQL is implemented.
> Exerted from MySQL documents:
> mysql> SELECT year, country, product, SUM(profit)
> -> FROM sales
> -> GROUP BY year, country, product WITH ROLLUP;
> +------+---------+------------+-------------+
> | year | country | product | SUM(profit) |
> +------+---------+------------+-------------+
> | 2000 | Finland | Computer | 1500 |
> | 2000 | Finland | Phone | 100 |
> | 2000 | Finland | NULL | 1600 |
> | 2000 | India | Calculator | 150 |
> | 2000 | India | Computer | 1200 |
> | 2000 | India | NULL | 1350 |
> | 2000 | USA | Calculator | 75 |
> | 2000 | USA | Computer | 1500 |
> | 2000 | USA | NULL | 1575 |
> | 2000 | NULL | NULL | 4525 |
> | 2001 | Finland | Phone | 10 |
> | 2001 | Finland | NULL | 10 |
> | 2001 | USA | Calculator | 50 |
> | 2001 | USA | Computer | 2700 |
> | 2001 | USA | TV | 250 |
> | 2001 | USA | NULL | 3000 |
> | 2001 | NULL | NULL | 3010 |
> | NULL | NULL | NULL | 7535 |
> +------+---------+------------+-------------+
> http://dev.mysql.com/doc/refman/5.0/en/group-by-modifiers.html
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira