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

["Anoop Sharma (JIRA)" <ji...@apache.org>]

Anoop Sharma created TRAFODION-2246:
---------------------------------------

             Summary: 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.4#6332)