FunctionsArray

array_jaccard_index

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

array_jaccard_index(…) → Float64

Kind · scalar

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

Part of the Array family.

array_intersect

Returns unique elements from the first array that are present in every other provided array.

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…