[
https://issues.apache.org/jira/browse/CALCITE-370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde closed CALCITE-370.
-------------------------------
Closing now that 1.0.0-incubating has been released.
> Support GROUPING SETS in SQL and algebra
> ----------------------------------------
>
> Key: CALCITE-370
> URL: https://issues.apache.org/jira/browse/CALCITE-370
> Project: Calcite
> Issue Type: Bug
> Reporter: Julian Hyde
> Assignee: Julian Hyde
> Fix For: 1.0.0-incubating
>
>
> Support grouping sets in the relational algebra. This feature would add a new
> field, groupKeys, to aggregate rel that has a set of bit maps, each of which
> has a grouping key.
> For example, if 'group by x, y, z' is represented by
> {code}
> AggregateRel(groupSet={0, 1, 2})
> {code}
> then 'group by grouping sets (x, y, z), (y, z), ()' would be represented by
> {code}
> AggregateRel(groupSet={0, 1, 2}, groupSets=[ {0, 1, 2}, {1, 2}, {} ])
> {code}
> A regular group by, or a group by with a singleton grouping set, would have
> groupSets = null.
> If groupSets is present, the returned row type would include an indicator
> column for each grouping key.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
