[HIVE-2397] Support with rollup option for group by

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.10.0
• Labels: TODOC10
• Assignee: Namit Jain
• Reporter: Kevin Wilfong
• Created: 19/Aug/11 19:32
• Updated: 23/Jun/18 16:44
• Resolved: 17/Sep/12 04:24

Description

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

Issue Links

• is cloned by: HIVE-3433 Implement CUBE and ROLLUP operators in Hive
• is related to: IMPALA-7204 Add support for GROUP BY ROLLUP, CUBE and GROUPING SETS