[ https://issues.apache.org/jira/browse/HIVE-16120?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jesus Camacho Rodriguez reassigned HIVE-16120: ---------------------------------------------- > 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)