-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 1.12.0
-
Component/s: None
-
Labels:None
When initially added to the SQL standard GROUPING took one argument, a column reference. Now it can have multiple arguments, like the GROUPING_ID function.
In SQL standard 2014, see section 6.9 <set function specification>, and feature T433, "Multiargument GROUPING function".
This change would extend GROUPING to allow one or more arguments (i.e. what GROUPING_ID currently does), and make GROUPING_ID a synonym for GROUPING. GROUP_ID is not affected, and continues to take zero arguments.
- is related to
-
HIVE-15996 Implement multiargument GROUPING function
-
- Closed
-
- relates to
-
CALCITE-1069 In Aggregate, deprecate indicators, and allow GROUPING to be used as an aggregate function
-
- Closed
-