Rohit Agarwal created HIVE-6950: ----------------------------------- Summary: 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
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 '' line 7:31 extraneous input ')' expecting eof near '' {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.2#6252)