Hive
  1. Hive
  2. HIVE-2397

Support with rollup option for group by

    Details

    • Type: New Feature New Feature
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.10.0
    • Component/s: None
    • Labels:

      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

      1. HIVE-2397.5.patch.txt
        723 kB
        Kevin Wilfong
      2. HIVE-2397.4.patch.txt
        723 kB
        Kevin Wilfong
      3. HIVE-2397.3.patch.txt
        706 kB
        Kevin Wilfong
      4. HIVE-2397.2.patch.txt
        705 kB
        Kevin Wilfong

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

            • Assignee:
              Namit Jain
              Reporter:
              Kevin Wilfong
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development