COLLECT_SET

Collects a set of all values for a given field.

Syntax

COLLECT_SET([MAX_VALUES,] VALUE)

Arguments

MAX_VALUES

Type: integer

Default: 2,147,483,647

(Optional) The maximum number of entries that can be counted. If it is omitted there is effectively no limit.

VALUE

Type: any type

The field to be collected.

Returns

Type: array

Array of the collected VALUE for each group.