[
https://issues.apache.org/jira/browse/TRAFODION-2246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anoop Sharma resolved TRAFODION-2246.
-------------------------------------
Resolution: Fixed
> add support for GROUP BY ROLLUP feature
> ---------------------------------------
>
> Key: TRAFODION-2246
> URL: https://issues.apache.org/jira/browse/TRAFODION-2246
> Project: Apache Trafodion
> Issue Type: New Feature
> Reporter: Anoop Sharma
> Assignee: Anoop Sharma
> Priority: Minor
>
> group by rollup can accumulate rollup data and return it when a group
> or a member of a group changes.
> For ex:
> select a,b,sum(c) from t group by rollup (a,b)
> will return an extra row when group 'a' changes or when all groups
> are returned. Change is detected from left to right of the specified
> groups in the rollup clause. Grouping columns to the right of the
> changed group are returned as NULL values.
> Rollup grouping is equivalent to:
> select a,b,sum(c) from t group by (a,b) union all
> select, a, null, sum(c) from t group by (a) union all
> select null, null, sum(c) from t;
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
