Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-2397

Support with rollup option for group by

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: 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

        Attachments

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

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: