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

Remove empty grouping sets restriction

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.2.0
    • Fix Version/s: None
    • Component/s: Parser
    • Labels:
      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

            Activity

              People

              • Assignee:
                jcamachorodriguez Jesus Camacho Rodriguez
                Reporter:
                jcamachorodriguez Jesus Camacho Rodriguez
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: