ARRAY_REMOVE (Lakehouse v2)
Removes all occurrences of a specified element from an array.
Analyze Syntax
Section titled “Analyze Syntax”func.array_remove([1, 2, 3, 2, 1], 2)Analyze Examples
Section titled “Analyze Examples”func.array_remove([1, 2, 3, 2, 1], 2)
┌─────────┐│ [1,3,1] │└─────────┘SQL Syntax
Section titled “SQL Syntax”ARRAY_REMOVE([1, 2, 3, 2, 1], 2)SQL Examples
Section titled “SQL Examples”SELECT ARRAY_REMOVE([1, 2, 3, 2, 1], 2);
┌─────────┐│ [1,3,1] │└─────────┘