Dongjoon Hyun created TAJO-1420:
-----------------------------------
Summary: Support GROUPING SET syntax
Key: TAJO-1420
URL: https://issues.apache.org/jira/browse/TAJO-1420
Project: Tajo
Issue Type: Improvement
Components: parser
Affects Versions: 0.10.0
Reporter: Dongjoon Hyun
Assignee: Dongjoon Hyun
Priority: Minor
Fix For: 0.10.1
This issue is about SQL parsing only. As of Tajo 0.10.0,
{code:sql}
default> create table t(a int, b int);
OK
default> select * from t group by cube(a,b);
ERROR: Cube is not supported yet
default> select * from t group by rollup(a,b);
ERROR: Rollup is not supported yet
default> select * from t group by grouping set(a,b);
ERROR: syntax error at or near 'grouping'
{code}
The last error should be like the following.
{code:sql}
default> select * from t group by grouping set(a,b);
ERROR: GroupingSet is not supported yet
{code}
As you know,
{code:sql}
GROUP BY a, b, c WITH CUBE
{code}
is equivalent to
{code:sql}
GROUP BY a, b, c GROUPING SETS ( (a, b, c), (a, b), (b, c), (a, c), (a), (b),
(c), ( ))
{code}
And,
{code:sql}
GROUP BY a, b, c, WITH ROLLUP
{code}
is equivalent to
{code:sql}
GROUP BY a, b, c GROUPING SETS ( (a, b, c), (a, b), (a), ( ))
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
