ARRAY_INDEXOF (Lakehouse v1)
Returns the index(1-based) of an element if the array contains the element.
Analyze Syntax
Section titled “Analyze Syntax”func.array_indexof( <array>, <element> )Analyze Examples
Section titled “Analyze Examples”func.array_indexof([1, 2, 9], 9)
┌───────────────────────────────────┐│ func.array_indexof([1, 2, 9], 9) │├───────────────────────────────────┤│ 3 │└───────────────────────────────────┘SQL Syntax
Section titled “SQL Syntax”ARRAY_INDEXOF( <array>, <element> )SQL Examples
Section titled “SQL Examples”SELECT ARRAY_INDEXOF([1, 2, 9], 9);
┌─────────────────────────────┐│ array_indexof([1, 2, 9], 9) │├─────────────────────────────┤│ 3 │└─────────────────────────────┘