[ 
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)

Reply via email to