[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 ] Swarnim Kulkarni updated HIVE-2397: --- Labels: TODOC10 (was: ) 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 Labels: TODOC10 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 was sent by Atlassian JIRA (v6.2#6252)
[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 ] Namit Jain updated HIVE-2397: - Status: Patch Available (was: Open) 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
[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 ] 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
[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 ] Kevin Wilfong updated HIVE-2397: Attachment: HIVE-2397.5.patch.txt 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: Kevin Wilfong 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: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira
[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 ] Kevin Wilfong updated HIVE-2397: Attachment: HIVE-2397.4.patch.txt 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: Kevin Wilfong Attachments: HIVE-2397.2.patch.txt, HIVE-2397.3.patch.txt, HIVE-2397.4.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. For more information on JIRA, see: http://www.atlassian.com/software/jira
[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 ] Kevin Wilfong updated HIVE-2397: Attachment: HIVE-2397.2.patch.txt 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: Kevin Wilfong Attachments: HIVE-2397.2.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. For more information on JIRA, see: http://www.atlassian.com/software/jira
[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 ] Kevin Wilfong updated HIVE-2397: Attachment: HIVE-2397.3.patch.txt 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: Kevin Wilfong Attachments: HIVE-2397.2.patch.txt, HIVE-2397.3.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. For more information on JIRA, see: http://www.atlassian.com/software/jira