ARRAY_FILTER

Learn how to use the ARRAY_FILTER array function in PlaidCloud Lakehouse. Filters elements in an array using a lambda expression - with syntax and examples.

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] │
└─────────┘