Release Notes November 22, 2023

No new features for Observe instances.

OPAL Language Updates

arrays_overlap

Type of operation: Filter

Description

Compares if two arrays have at least one element in common. Returns true if there is at least one element in common. Otherwise, OPAL returns false.

The function is NULL-safe, meaning if both arrays contain a null element, it is considered to be an overlapping element and arrays_overlap() returns true.

Return type

boolean

Domain

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

Usage

arrays_overlap( input_array_1, input_array_2 )

Argument	Type	Required	Multiple	Constant
input_array_1	array	Required	Only one	Variable
input_array_2	array	Required	Only one	Variable

Examples

make_col foo:arrays_overlap(make_array('hello', 'goodbye'), make_array('katze', 'hund'))

Make the column ‘foo’ with a False as the input arrays have no overlap.

filter arrays_overlap(names, places)

Filter to include all rows whose names column (an array) overlaps with the places column (another array).

make_col foo:arrays_overlap(make_array('hello', variant_null()), make_array('katze', variant_null()))

Make the column ‘foo’ with a True as the input arrays overlap on the null value.