Array accumulators

Accumulators applicable to arrays

count
Alias: count
Overview

Counts the number of accumulated items, including null values.

first
Alias: first
Overview

Stores the first accumulated item and ignores all subsequent items.

last
Alias: last
Overview

Stores the most recently accumulated item.

max
Alias: max
Overview

Tracks the greatest numeric value found during accumulation.

min
Alias: min
Overview

Tracks the smallest numeric value found during accumulation.

sum
Alias: sum
Overview

Computes the sum of all accumulated numeric values.


Temporal predicates
Programmatically build an expression

Related Docs