[HIVE-12833] GROUPING__ID is wrong

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: Davies Liu
• Created: 09/Jan/16 20:48
• Updated: 01/Sep/17 18:10

Description

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.

Issue Links

• is related to: SPARK-21858 Make Spark grouping_id() compatible with Hive grouping__id