[HIVE-15045] Count distinct throws error when used in conjunction with grouping set

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.0.0, 1.1.0, 1.2.0, 2.0.0, 2.1.0
• Component/s: Operators
• Assignee: Unassigned
• Reporter: Ashutosh Chauhan
• Created: 24/Oct/16 20:16
• Updated: 27/Feb/24 22:24

Description

SELECT key, value, count(distinct value) FROM src GROUP BY key, value with cube;
FAILED: SemanticException [Error 10210]: Grouping sets aggregations (with rollups or cubes) are not allowed if aggregation function parameters overlap with the aggregation functions columns