[SPARK-40151] Fix return type for new median(interval) function

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 3.4.0
• Fix Version/s: 3.4.0
• Component/s: Spark Core
• Assignee: Max Gekk
• Reporter: Serge Rielau
• Created: 19/Aug/22 17:55
• Updated: 22/Aug/22 08:12
• Resolved: 22/Aug/22 08:12

Description

median() right now returns an interval of the same type as the input.
We should instead match mean and avg():

The result type is computed as for the arguments:

• year-month interval: The result is an `INTERVAL YEAR TO MONTH`.
• day-time interval: The result is an `INTERVAL DAY TO SECOND`.
• In all other cases the result is a DOUBLE.

Issue Links

• links to: [Github] Pull Request #37595 (MaxGekk)
• links to: [Github] Pull Request #37595 (MaxGekk)