[
https://issues.apache.org/jira/browse/CALCITE-5710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17723862#comment-17723862
]
jackylau commented on CALCITE-5710:
-----------------------------------
comments:
spark docs:
array_max Returns the maximum value in the array. NaN is greater than any
non-NaN elements for double/float type. NULL elements are skipped.
i add NaN is greater than any non-NaN elements for double/float type it to
calcite docs
because the NAN compareTo others always return true in java so the result is
same with spark.
but it will confuse user if it is in the doc
> Add ARRAY_MAX and ARRAY_MIN for Spark dialect
> ---------------------------------------------
>
> Key: CALCITE-5710
> URL: https://issues.apache.org/jira/browse/CALCITE-5710
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.34.0
> Reporter: jackylau
> Priority: Major
> Fix For: 1.35.0
>
>
> ARRAY_MAX - Returns the maximum value in the array
> ARRAY_MIN - Returns the minmum value in the array
>
> For more details
> [https://spark.apache.org/docs/latest/api/sql/index.html]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
