[SPARK-21423] MODE average aggregate function.

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Incomplete
• Affects Version/s: 2.2.0
• Component/s: SQL
• Labels: bulk-closed
• Assignee: Unassigned
• Reporter: Mathew Wicks
• Created: 15/Jul/17 04:46
• Updated: 21/May/19 04:11
• Resolved: 21/May/19 04:11

Description

Having a MODE() aggregate function which returns the mode average of a group/window would be very useful.

For example, if the column type is a number, it finds the most common number, and if the column type is a string, it finds the most common string.

I appreciate that doing this in a scalable way will require some thinking/discussion.