Applies to: Databricks SQL Databricks Runtime
Returns an array consisting of all unique values in
expr within the group.
collect_set(expr) [FILTER ( WHERE cond ) ]
This function can also be invoked as a window function using the
expr: An expression of any type.
cond: An optional boolean expression filtering the rows used for aggregation.
An ARRAY of the argument type.
The order of elements in the array is non-deterministic. NULL values are excluded.