FunctionsArray

array_last

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

array_last(…) → String

Kind · scalar

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

Part of the Array family.

array_join

Produces one output row per element of the input array, effectively 'exploding' the array for relational processing. Use array_join in lateral contexts to turn arrays into rows that can be filtered…

array_last_index

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