Implement array_except function #6979
Description
Is your feature request related to a problem or challenge?
Summary
| Characteristic | Description |
|---|---|
| Function name: | array_except |
| Aliases: | list_except |
| Original function?: | No |
| Function Description: | Azure DataBricks: Returns an array of the elements in array1 but not in array2. Spark SQL: Returns all elements from col1 array but not in col2 array. |
| Sources: | Concept Azure Spark |
Examples:
select array_except([1, 2, 3, 4], [2, 3, 1, 5]);
----
[4, 5]
select array_except([1, 2, 2, 3, 4], [1, 3, 1, 5]);
----
[2, 4]
Describe the solution you'd like
No response
Describe alternatives you've considered
No response
Additional context
No response