COLLECT_SET_EACH
Last updated
Last updated
Collects a set of all values per group for a given field.
COLLECT_SET_EACH([MAX_VALUES,] GROUP, VALUE)
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.
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.