Collect distinct array

Supported in: Batch, Streaming

Collects an array of deduplicated values within each group. Null values are ignored.

Expression categories: Aggregate

Declared arguments

• Expression - The column of values to collect into an array, keeping distinct values only.
  Expression<T>

Type variable bounds: T accepts ComparableType

Output type: Array<T>

Examples

Example 1: Base case

Argument values:

• Expression: factor

Given input table:

Outputs: [ 2, 3 ]

---

Example 2: Null case

Argument values:

• Expression: factor

Given input table:

Outputs: [ 2, 3 ]

---