COLLECT_SET_EACH

Collects a set of all values per group for a given field.

Syntax

COLLECT_SET_EACH([MAX_VALUES,] GROUP, VALUE)

Arguments

MAX_VALUES

Type: integer

Default: 2,147,483,647

(Optional) The maximum number of entries that are counted. When omitted, there is effectively no limit.

GROUP

Type: any

The field by which to group the results.

VALUE

Type: any

The field to be collected.

Returns

Type: array

Returns an array of key-value pairs where each GROUP is matched to the collected set of all values VALUE seen for that group.