[
https://issues.apache.org/jira/browse/CALCITE-370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde resolved CALCITE-370.
---------------------------------
Resolution: Fixed
Fix Version/s: 1.0.0-incubating
Fixed in
http://git-wip-us.apache.org/repos/asf/incubator-calcite/commit/6d79b5ebf7b1fa40455eb3df82998c58a8e08b8d.
> 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)
