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