Links
Comment on page

FIRST_EACH

Gets an array of the first values per given group in the time window.
Note that this function is non-deterministic.

Syntax

FIRST_EACH([MAX_VALUES,] GROUP, VALUE)

Arguments

MAX_VALUES

Type: integer
Default: 2,147,483,647
(Optional) Limits the number of key value elements in the output.

GROUP

Type: any
The field to group by.

VALUE

Type: any
The field to get the first value of.

Returns

Type: array
Returns an array of key-value pairs where each GROUP is matched to the first VALUE seen for that group.