ARRAY_APPLY

Description

Filter array to match specific binary condition

Syntax

ARRAY_APPLY(<arr>, <op>, <val>)

Parameters

Parameter	Description
<arr>	Input array
<op>	Filter condition, including =, >=, <=, >, <, !=
<val>	Filter value. If null, the result will be null. Only constant values are supported.

Return Value

The filtered array matched with condition.

Example

select array_apply([1, 2, 3, 4, 5], ">=", 2);

+--------------------------------------------+
| array_apply(ARRAY(1, 2, 3, 4, 5), '>=', 2) |
+--------------------------------------------+
| [2, 3, 4, 5]                               |
+--------------------------------------------+

select array_apply([1000000, 1000001, 1000002], "=", "1000002");

+-------------------------------------------------------------+
| array_apply(ARRAY(1000000, 1000001, 1000002), '=', 1000002) |
+-------------------------------------------------------------+
| [1000002]                                                   |
+-------------------------------------------------------------+