[
https://issues.apache.org/jira/browse/TRAFODION-2312?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15645262#comment-15645262
]
ASF GitHub Bot commented on TRAFODION-2312:
-------------------------------------------
GitHub user anoopsharma00 opened a pull request:
https://github.com/apache/incubator-trafodion/pull/824
[TRAFODION-2312] Add support for GROUPING_ID function
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/anoopsharma00/incubator-trafodion
ansharma_trafr21_br
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/824.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #824
----
commit 449691b25489218b458281ee7c4044f6ad088e86
Author: Anoop Sharma <[email protected]>
Date: 2016-11-07T19:58:52Z
[TRAFODION-2312] Add support for GROUPING_ID function
----
> Add support for GROUPING function for rollup aggregation
> --------------------------------------------------------
>
> Key: TRAFODION-2312
> URL: https://issues.apache.org/jira/browse/TRAFODION-2312
> Project: Apache Trafodion
> Issue Type: New Feature
> Reporter: Anoop Sharma
> Assignee: Anoop Sharma
> Priority: Minor
>
> GROUP BY ROLLUP aggregation generates and returns a null value to
> represent a rollup group.
> See jira trafodion-2246 for ROLLUP details.
> This current jira is an extension of it.
> GROUPING function is used to determine whether a returned null value
> is due to a rollup group.
> It returns '1' if a null value is a rollup null and '0' otherwise (for
> non-null
> or data null values).
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)