FIRST_EACH

Returns 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.