hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Namit Jain (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-2397) Support with rollup option for group by
Date Mon, 17 Sep 2012 04:25:16 GMT

     [ 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

Mime
View raw message