[HIVE-6950] Parsing Error in GROUPING SETS - ASF JIRA

XML

Word

Printable

JSON

The following query:

SELECT tab1.a,
       tab1.b,
       SUM(tab1.c)
FROM tab1
GROUP BY tab1.a,
         tab1.b
GROUPING SETS ((tab1.a, tab1.b))

results in the following error:

ParseException line 7:22 missing ) at ',' near '<EOF>'
line 7:31 extraneous input ')' expecting EOF near '<EOF>'

Changing the query to:

SELECT tab1.a,
       tab1.b,
       SUM(tab1.c)
FROM tab1
GROUP BY tab1.a,
         tab1.b
GROUPING SETS ((a, tab1.b))

makes it work.

is duplicated by

HIVE-7178 Table alias cannot be used in GROUPING SETS clause if there are more than one column in it

relates to

HIVE-6617 Reduce ambiguity in grammar