[ https://issues.apache.org/jira/browse/HIVE-2397?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-2397: ----------------------------- Resolution: Fixed Status: Resolved (was: Patch Available) duplicate of HIVE-3433 > 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 > 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