[CALCITE-1652] Allow GROUPING to have multiple arguments, like GROUPING_ID

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.12.0
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 21/Feb/17 19:18
• Updated: 24/Mar/17 03:20
• Resolved: 22/Feb/17 19:46

Description

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.

Issue Links

• is related to: HIVE-15996 Implement multiargument GROUPING function
• relates to: CALCITE-1069 In Aggregate, deprecate indicators, and allow GROUPING to be used as an aggregate function