pyflink.table.expression.Expression.array_except

Expression.array_except(array) → pyflink.table.expression.Expression

Returns an ARRAY that contains the elements from array1 that are not in array2. If no elements remain after excluding the elements in array2 from array1, the function returns an empty ARRAY. If one or both arguments are NULL, the function returns NULL. The order of the elements from array1 is kept however the duplicates are removed.

New in version 1.12.0.