collect_set
aggregate function
Applies to: Databricks SQL Databricks Runtime
Returns an array consisting of all unique values in expr
within the group.
Syntax
collect_set(expr) [FILTER ( WHERE cond ) ]
This function can also be invoked as a window function using the OVER
clause.
Arguments
expr
: An expression of any type exceptMAP
.cond
: An optional boolean expression filtering the rows used for aggregation.