DB
FunctionsArray

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_join(…) → String

Kind · stream

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, aggregated, or joined.

Part of the Array family.

array_jaccard_index

Calculates |A intersect B| divided by |A union B| using distinct tokens from each input array.

array_last

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