[
https://issues.apache.org/jira/browse/TAJO-1420?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dongjoon Hyun updated TAJO-1420:
--------------------------------
Description: (was: 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})
Summary: Implement GROUPING SET (was: Support GROUPING SET syntax)
> Implement GROUPING SET
> ----------------------
>
> Key: TAJO-1420
> URL: https://issues.apache.org/jira/browse/TAJO-1420
> Project: Tajo
> Issue Type: Sub-task
> Components: parser
> Affects Versions: 0.10.0
> Reporter: Dongjoon Hyun
> Assignee: Dongjoon Hyun
> Priority: Minor
> Fix For: 0.10.1
>
> Attachments: TAJO-1420.patch
>
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
