intersect_arrays(array_1: array, array_2: array) -> generic array

Returns an array containing the matching elements inside the two input arrays.

The multiplicity of a value in the output array will be the minimum multiplicity of that value in the two input arrays. The function is NULL-safe, meaning it treats NULLS as known values for comparing equality: if both input arrays contain a NULL value, then the resulting output array will also contain a NULL.

Domain

This is a scalar function (calculates a single output value for a single input row).

Categories

• Semistructured

Examples

Make the column 'foo' with array ['green'].

Make the column 'foo' with array [0, 0, 1].

Make the column 'foo' with array [null].