[FLINK-22726] Hive GROUPING__ID returns different value in older versions

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.13.0
• Fix Version/s: 1.14.0, 1.13.2
• Component/s: Connectors / Hive
• Labels: pull-request-available
• Assignee: Rui Li
• Reporter: Rui Li
• Created: 20/May/21 13:09
• Updated: 23/Sep/21 17:25
• Resolved: 09/Jun/21 05:58

Description

Hive's GROUPING__ID changed since 2.3.0. In current implementation we use Calcite's GROUPING_ID operator which yields same value as hive >= 2.3.0. When integrate with older hive, we should follow the previous behavior.

Refer to:
https://issues.apache.org/jira/browse/HIVE-16102
https://cwiki.apache.org/confluence/display/Hive/Enhanced+Aggregation%2C+Cube%2C+Grouping+and+Rollup#EnhancedAggregation,Cube,GroupingandRollup-Grouping__IDfunction(beforeHive2.3.0)

Issue Links

• links to: GitHub Pull Request #15983