[SPARK-45796] Support MODE() WITHIN GROUP (ORDER BY col)

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Jiaan Geng
• Reporter: Jiaan Geng
• Created: 05/Nov/23 07:36
• Updated: 10/May/24 06:40
• Resolved: 14/Dec/23 11:21

Description

Many mainstream databases supports the syntax show below.

{ MODE() WITHIN GROUP (ORDER BY sortSpecification) }

[FILTER (WHERE expression)] [OVER windowNameOrSpecification]

Issue Links

• is duplicated by: SPARK-45904 Mode function supports sort direction
• links to: GitHub Pull Request #43663
• links to: GitHub Pull Request #44184