[SPARK-30396] When there are multiple DISTINCT aggregate expressions acting on different fields, any DISTINCT aggregate expression allows the use of the FILTER clause

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Jiaan Geng
• Created: 31/Dec/19 08:17
• Updated: 16/Jan/20 09:54
• Resolved: 16/Jan/20 09:54

Description

This ticket is related to https://issues.apache.org/jira/browse/SPARK-27986

This ticket will support:

When there are multiple DISTINCT aggregate expressions acting on different fields, any DISTINCT aggregate expression allows the use of the FILTER clause

 such as:
select class_id, count(distinct sex), sum(distinct id) filter (where sex = 'man') from student group by class_id;
select class_id, count(distinct sex) filter (where class_id = 1), sum(distinct id) filter (where sex = 'man') from student group by class_id;