Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Databricks SQL Databricks Runtime
Removes all occurrences of element from array.
Syntax
array_remove(array, element)
Arguments
array: An ARRAY.element: An expression of a type sharing a least common type with the elements ofarray.
Returns
The result type matched the type of the array.
If the element to be removed is NULL, the result is NULL.
Examples
> SELECT array_remove(array(1, 2, 3, NULL, 3, 2), 3);
[1,2,NULL,2]
> SELECT array_remove(array(1, 2, 3, NULL, 3, 2), NULL);
NULL