array_except
function
Applies to: Databricks SQL Databricks Runtime
Returns an array of the elements in array1
but not in array2
.
Syntax
array_except(array1, array2)
Arguments
array1
: An ARRAY of any type with comparable elements.array2
: An ARRAY of elements sharing a least common type with the elements ofarray1
.
Returns
An ARRAY of matching type to array1
with no duplicates.
Examples
> SELECT array_except(array(1, 2, 2, 3), array(1, 1, 3, 5));
[2]
Related
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for