[jira] [Created] (HIVE-16120) Remove empty grouping sets restriction

["Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org>]

Jesus Camacho Rodriguez created HIVE-16120:
----------------------------------------------

             Summary: Remove empty grouping sets restriction
                 Key: HIVE-16120
                 URL: https://issues.apache.org/jira/browse/HIVE-16120
             Project: Hive
          Issue Type: Improvement
          Components: Parser
    Affects Versions: 2.2.0
            Reporter: Jesus Camacho Rodriguez
            Assignee: Jesus Camacho Rodriguez


Queries with empty grouping sets, such as the following:
{code:sql}
SELECT a FROM T1 GROUP BY a GROUPING SETS (());
{code}
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.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)