Returns the number of distinct (unique) elements in the array. As with COUNT and COUNT(DISTINCT ...) aggregations, NULL is not counted as a value if it occurs.

​
Syntax

ARRAY_COUNT_DISTINCT(<array>)

​
Parameters

ParameterDescriptionSupported input types
<array>The array of which to count the distinct elements.Any ARRAY type

​
Return Type

INTEGER

​
Example

SELECT ARRAY_COUNT_DISTINCT([ 1, 2, 4, 5, 2, NULL, 5, 1 ]) AS res;
Returns: 4