[SPARK-27425] Add count_if functions

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.4.1
• Fix Version/s: 3.0.0
• Component/s: SQL
• Assignee: Chaerim Yeo
• Reporter: Chaerim Yeo
• Created: 10/Apr/19 09:12
• Updated: 12/Dec/22 18:10
• Resolved: 10/Jun/19 10:53

Description

Add aggregation function which returns the number of records satisfying a given condition.

For Presto, count_if function is supported, we can write concisely.

However, Spark does not support yet, we need to write like COUNT(CASE WHEN some_condition THEN 1 END) or SUM(CASE WHEN some_condition THEN 1 END), which looks painful.

Issue Links

• links to: GitHub Pull Request #24335