You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Davies Liu (JIRA)" <ji...@apache.org> on 2016/01/09 21:48:39 UTC

[jira] [Created] (HIVE-12833) GROUPING__ID is wrong

Davies Liu created HIVE-12833:
---------------------------------

             Summary: GROUPING__ID is wrong
                 Key: HIVE-12833
                 URL: https://issues.apache.org/jira/browse/HIVE-12833
             Project: Hive
          Issue Type: Bug
            Reporter: Davies Liu


https://cwiki.apache.org/confluence/display/Hive/Enhanced+Aggregation,+Cube,+Grouping+and+Rollup

Grouping__ID function

This function returns a bitvector corresponding to whether each column is present or not. For each column, a value of "1" is produced for a row in
the result set if that column has been aggregated in that row, otherwise the value is "0". This can be used to differentiate when there are nulls
in the data.

This does not match the example blow, in the first row, both key and value are aggregated, so GROUPING__ID should be 3 not, 0.



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