[HIVE-15994] Grouping function error when grouping sets are not specified

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.0
• Fix Version/s: 2.2.0
• Target Version/s: 2.2.0
• Assignee: Jesús Camacho Rodríguez
• Reporter: Carter Shanklin
• Created: 21/Feb/17 10:24
• Updated: 27/Feb/24 22:24
• Resolved: 27/Feb/17 08:56

Description

hive> select grouping(c1), lead(c2) over(partition by grouping(c1)) from e011_01 group by c1, c2;
FAILED: SemanticException Failed to breakup Windowing invocations into Groups. At least 1 group must only depend on input columns. Also check for circular dependencies.
Underlying error: org.apache.hadoop.hive.ql.parse.SemanticException: Line 1:48 Arguments length mismatch 'c1': grouping() requires 2 argument, got 1

Issue Links

• blocks: HIVE-15996 Implement multiargument GROUPING function
• links to: RB link