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

Support with rollup option for group by

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 0.10.0
    • None

    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.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

            People

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

              Dates

                Created:
                Updated:
                Resolved: