ARRAY_FILTER
Filters elements in an array using a lambda expression.
Analyze Syntax
func.array_filter(get_column(table, 'arr'), lambda x: x > 2)
Analyze Examples
func.array_filter([1, 2, 3, 4, 5], lambda x: x > 2)
┌─────────┐
│ [3,4,5] │
└─────────┘
SQL Syntax
ARRAY_FILTER(<arr>, lambda x: x > 2)
SQL Examples
SELECT ARRAY_FILTER([1, 2, 3, 4, 5], x -> x > 2);
┌─────────┐
│ [3,4,5] │
└─────────┘