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)
