Repository navigation
Add array_min function support #14416
Description
Is your feature request related to a problem or challenge?
Currently, Spark, Snowflake and Presto support array_min function. This can also be useful for DataFusion.
array_min(make_array(3,1,4,2)) => 1
array_min(make_array('h','e','l','l',NULL,'o')) => e
array_min(make_array(NULL,NULL)) => NULL
Spark: https://docs.databricks.com/en/sql/language-manual/functions/array_min.html
Snowflake: https://docs.snowflake.com/en/sql-reference/functions/array_min
Presto: https://prestodb.io/docs/current/functions/array.html#array_min-x-x
Describe the solution you'd like
Adding array_min function support to DataFusion.
Describe alternatives you've considered
No response
Additional context
No response
Activity
erenavsarogullari commentedon Feb 3, 2025
take
Omega359 commentedon Feb 3, 2025
Possibly related/tangential: #14392
erenavsarogullari commentedon Feb 3, 2025
@Omega359 Thanks for the comment. Yes, this effort is also related with #14392.
I think we have 2 use cases for
array_min&array_maxfunctions (and i think this also common requirement for other SQL functions.). They are required for DataFusion end-users (not using Comet) and Comet support is another use-case because Spark supports them natively and DataFusion has not supported yet. We will also need for the mapping on Comet side for Spark queries using this scalar array functions submitted to DataFusion by Comet.[-]Add array_min function support[/-][+]Add `array_min` function support[/+]Jefffrey commentedon Sep 27, 2025
Implemented by #16574
array_minscalar function #16570