snowflake.snowpark.functions.array_min¶
- snowflake.snowpark.functions.array_min(array: Union[Column, str]) Column [source]¶
Returns smallest defined non-NULL element in the input array. If the input array is empty, or there is no defined element in the input array, then the function returns NULL.
Make sure BCR 2023_05 Bundle is enabled before using this function.
- Parameters:
array – the input array
- Returns:
a VARIANT containing the smallest defined element in the array, or NULL
- Examples::
- Behavior with SQL nulls:
>>> df = session.sql("select array_construct(20, 0, null, 10) as A") >>> df.select(array_min(df.a).as_("min_a")).collect() [Row(MIN_A='0')] >>> df = session.sql("select array_construct() as A") >>> df.select(array_min(df.a).as_("min_a")).collect() [Row(MIN_A=None)] >>> df = session.sql("select array_construct(null, null, null) as A") >>> df.select(array_min(df.a).as_("min_a")).collect() [Row(MIN_A=None)]
- Behavior with JSON nulls:
>>> df = session.create_dataframe([[[None, None, None]]], schema=["A"]) >>> df.select(array_min(df.a).as_("min_a")).collect() [Row(MIN_A='null')]