You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Anoop Sharma (JIRA)" <ji...@apache.org> on 2017/02/17 22:10:45 UTC

[jira] [Resolved] (TRAFODION-2246) add support for GROUP BY ROLLUP feature

     [ 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)