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)

Type: integer

Default: 2,147,483,647

(Optional) Limits the number of key value elements in the output.

Type: any

The field to group by.

Type: any

The field to get the first value of.

Type: array

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

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!