GET (Array, Lakehouse v1)
Returns an element from an array by index (1-based).
Analyze Syntax
Section titled “Analyze Syntax”func.get( <array>, <index> )Analyze Examples
Section titled “Analyze Examples”func.get([1, 2], 2)
┌─────────────────────┐│ func.get([1, 2], 2) │├─────────────────────┤│ 2 │└─────────────────────┘SQL Syntax
Section titled “SQL Syntax”GET( <array>, <index> )Aliases
Section titled “Aliases”SQL Examples
Section titled “SQL Examples”SELECT GET([1, 2], 2), ARRAY_GET([1, 2], 2);
┌───────────────────────────────────────┐│ get([1, 2], 2) │ array_get([1, 2], 2) │├────────────────┼──────────────────────┤│ 2 │ 2 │└───────────────────────────────────────┘