ARRAY_CONTAINS (Lakehouse v2)

Checks whether an array contains a specific element.

Analyze Syntax

func.array_contains([1, 2, 3], 2)

Analyze Examples

func.array_contains([1, 2, 3], 2)

┌───┐
│ 1 │
└───┘

SQL Syntax

ARRAY_CONTAINS([1, 2, 3], 2)

SQL Examples

SELECT ARRAY_CONTAINS([1, 2, 3], 2);

┌───┐
│ 1 │
└───┘