ANY_MATCH
Learn how to use the ANY_MATCH array function in PlaidCloud Lakehouse. Returns TRUE if any element in an array matches the given predicate.
Returns TRUE if any element in an array matches the given predicate.
Analyze Syntax
func.any_match(get_column(table, 'arr'), lambda x: x > 5)
Analyze Examples
func.any_match([1, 2, 8], lambda x: x > 5)
┌───┐
│ 1 │
└───┘
SQL Syntax
ANY_MATCH(<arr>, lambda x: x > 5)
SQL Examples
SELECT ANY_MATCH([1, 2, 8], x -> x > 5);
┌───┐
│ 1 │
└───┘