Upsolver SQLake
Contact Support
Search
⌃K
Links
Comment on page

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.
Previous
AVG_TIME_SERIES
Next
COLLECT_SET_EACH
Last modified 1yr ago