ARRAY_MIN
Returns the smallest element in Array a.
Syntax
T array_min(array<T> <a>) Parameters
a: required. This parameter specifies an array. T in array<T> specifies the data type of the elements in the array.
The following data types are supported:
TINYINT, SMALLINT, INT, and BIGINT
FLOAT and DOUBLE
BOOLEAN
DECIMAL and DECIMALVAL
DATE, DATETIME, TIMESTAMP, IntervalDayTime, and IntervalYearMonth
STRING, BINARY, VARCHAR, and CHAR
ARRAY, STRUCT, and MAP
Return value
The smallest element in Array a is returned. The return value varies based on the following rules:
If Array a is null, the return value is null.
If an element in Array a is null, the null element is not involved in the operation.
Examples
-- The return value is 1.
select array_min(array(1, 20, null, 3));Related functions
ARRAY_MIN is a complex type function. For more information about functions that are used to process data of complex data types, such as ARRAY, MAP, STRUCT, and JSON, see Complex type functions.