[jira] [Resolved] (HIVE-6950) Parsing Error in GROUPING SETS

["Pengcheng Xiong (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-6950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Pengcheng Xiong resolved HIVE-6950.
-----------------------------------
       Resolution: Fixed
    Fix Version/s: 1.2.0
         Assignee: Pengcheng Xiong
     Release Note: addressed in HIVE-6617

> Parsing Error in GROUPING SETS
> ------------------------------
>
>                 Key: HIVE-6950
>                 URL: https://issues.apache.org/jira/browse/HIVE-6950
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Rohit Agarwal
>            Assignee: Pengcheng Xiong
>             Fix For: 1.2.0
>
>
> The following query:
> {code}
> SELECT tab1.a,
>        tab1.b,
>        SUM(tab1.c)
> FROM tab1
> GROUP BY tab1.a,
>          tab1.b
> GROUPING SETS ((tab1.a, tab1.b))
> {code}
> results in the following error:
> {code}
> ParseException line 7:22 missing ) at ',' near '<EOF>'
> line 7:31 extraneous input ')' expecting EOF near '<EOF>'
> {code}
> Changing the query to:
> {code}
> SELECT tab1.a,
>        tab1.b,
>        SUM(tab1.c)
> FROM tab1
> GROUP BY tab1.a,
>          tab1.b
> GROUPING SETS ((a, tab1.b))
> {code}
> makes it work.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)