[GitHub] [spark] cloud-fan commented on a diff in pull request #37595: [SPARK-40151][SQL] Return wider ANSI interval types from the percentile functions

[GitBox <gi...@apache.org>]

cloud-fan commented on code in PR #37595:
URL: https://github.com/apache/spark/pull/37595#discussion_r951030541


##########
sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/expressions/aggregate/percentiles.scala:
##########
@@ -59,7 +59,8 @@ abstract class PercentileBase
 
   override lazy val dataType: DataType = {
     val resultType = child.dataType match {
-      case it: AnsiIntervalType => it
+      case _: YearMonthIntervalType => YearMonthIntervalType()
+      case _: DayTimeIntervalType => DayTimeIntervalType()

Review Comment:
   shall we still respect the start field? e.g. `median(interval minute)` returns internal minute to second`.



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org