FunctionsArray

array_first_index

Returns a one-based position of the first matching element, or zero when no element matches.

array_first_index(…) → UInt64

Kind · scalar

Returns a one-based position of the first matching element, or zero when no element matches.

Part of the Array family.

array_first

Extracts the first element from each input array and returns null for empty arrays.

array_first_or_null

Behaves like array_first while explicitly preserving null output for empty inputs.