[SPARK-28500] adds support for `filter` clause

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Dylan Guedes
• Created: 24/Jul/19 12:38
• Updated: 29/Dec/19 05:45
• Resolved: 29/Dec/19 05:45

Description

Definition: "The filter clause extends aggregate functions (sum, avg, count, …) by an additional where clause. The result of the aggregate is built from only the rows that satisfy the additional where clause too." [source|https://modern-sql.com/feature/filter]

Also, PgSQL currently support `filter` while Spark doesn't.

Issue Links

• Is contained by: SPARK-27986 Support Aggregate Expressions with filter