[SPARK-39320] Add the MEDIAN() function

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.4.0
• Fix Version/s: 3.4.0
• Component/s: SQL
• Assignee: Jiaan Geng
• Reporter: Max Gekk
• Created: 27/May/22 14:34
• Updated: 03/Jun/22 05:23
• Resolved: 03/Jun/22 05:23

Description

Add the MEDIAN() function which can be implemented as a specific case of PERCENTILE_CONT where the percentile value defaults to 0.5.

Issue Links

• relates to: SPARK-37676 Support ANSI Aggregation Function: percentile_cont
• links to: [Github] Pull Request #36714 (beliefer)