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)