Returns the number of distinct (unique) elements in the array. As withDocumentation Index
Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
Use this file to discover all available pages before exploring further.
COUNT and COUNT(DISTINCT ...) aggregations, NULL is not counted as a value if it occurs.
Syntax
Parameters
| Parameter | Description | Supported input types |
|---|---|---|
<array> | The array of which to count the distinct elements. | Any ARRAY type |
Return Type
INTEGER
Example
4