hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jesus Camacho Rodriguez (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (HIVE-16120) Remove empty grouping sets restriction
Date Mon, 06 Mar 2017 13:38:33 GMT

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

Mime
View raw message