ARRAY_POSITION (Lakehouse v2)

Returns the position of the first occurrence of an element (1-indexed).

Analyze Syntax

func.array_position([10, 20, 30], 20)

Analyze Examples

func.array_position([10, 20, 30], 20)

┌───┐
│ 2 │
└───┘

SQL Syntax

ARRAY_POSITION([10, 20, 30], 20)

SQL Examples

SELECT ARRAY_POSITION([10, 20, 30], 20);

┌───┐
│ 2 │
└───┘