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)