You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2014/12/09 09:48:12 UTC

[jira] [Created] (CALCITE-512) Add GROUP_ID and GROUPING_ID functions

Julian Hyde created CALCITE-512:
-----------------------------------

             Summary: Add GROUP_ID and GROUPING_ID functions
                 Key: CALCITE-512
                 URL: https://issues.apache.org/jira/browse/CALCITE-512
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde
            Assignee: Julian Hyde


Implement GROUP_ID and GROUPING_ID(expr [, expr]...) functions, as they are defined in Oracle.

We already have, as of CALCITE-370, the GROUPING(expr) function. Now define GROUPING_ID:

GROUPING_ID(e2, e1, e0)
 == GROUPING(e2) * 4 
  + GROUPING(e1) * 2
  + GROUPING(e0)

and similarly for different numbers of arguments.

GROUP_ID() is equivalent to GROUPING_ID(x, y, z), where x, y, z are the expressions being grouped.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)