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

Remove empty grouping sets restriction

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 2.2.0
    • None
    • Parser
    • None

    Description

      Queries with empty grouping sets, such as the following:

      SELECT a FROM T1 GROUP BY a GROUPING SETS (());

      are not allowed in Hive. The restriction was added in HIVE-3471, together with some negative tests. However, the reason why this restriction is included is not described in the JIRA case, and the review board link (where there might be some additional information) does not work anymore. After running some tests myself, empty grouping sets seems to be working perfectly even when it is on its own; thus, it seems we could lift this restriction.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-16102 Grouping sets do not conform to SQL standard

          • Critical - Crashes, loss of data, severe memory leak.
          • Resolved

          Activity

            People

              Unassigned Unassigned
              jcamacho Jesús Camacho Rodríguez
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated: