ARRAY_MAX

description

Get the maximum element in an array (NULL values are skipped). When the array is empty or all elements in the array are NULL values, the function returns NULL.

Syntax

ARRAY_MAX(<arr>)

Parameters

Parameter	Description
<arr>	ARRAY array

Return Value

Returns the largest element in the array. Special cases:

• NULL values in the array are skipped.
• For an empty array or an array where all elements are NULL, the result is NULL.

example

create table array_type_table(
    k1 INT, 
    k2 Array<int>
        ) 
duplicate key (k1)
distributed by hash(k1) buckets 1 
properties(
    'replication_num' = '1'
    );
insert into array_type_table values (0, []), (1, [NULL]), (2, [1, 2, 3]), (3, [1, NULL, 3]);
select k2, array_max(k2) from array_type_table;

+--------------+-----------------+
| k2           | array_max(`k2`) |
+--------------+-----------------+
| []           |            NULL |
| [NULL]       |            NULL |
| [1, 2, 3]    |               3 |
| [1, NULL, 3] |               3 |
+--------------+-----------------+