ARRAYS_ZIP (Lakehouse v1)
Merges multiple arrays into a single array tuple.
Analyze Syntax
Section titled “Analyze Syntax”func.arrays_zip( <array1> [, ...] )Analyze Examples
Section titled “Analyze Examples”func.arrays_zip([1, 2, 3], ['a', 'b', 'c'])
┌──────────────────────────────────────────────┐│ func.arrays_zip([1, 2, 3], ['a', 'b', 'c']) │├──────────────────────────────────────────────┤│ [(1,'a'),(2,'b'),(3,'c')] │└──────────────────────────────────────────────┘SQL Syntax
Section titled “SQL Syntax”ARRAYS_ZIP( <array1> [, ...] )Arguments
Section titled “Arguments”| Arguments | Description |
|---|---|
<arrayN> |
The input ARRAYs. |
Return Type
Section titled “Return Type”Array(Tuple).
SQL Examples
Section titled “SQL Examples”SELECT ARRAYS_ZIP([1, 2, 3], ['a', 'b', 'c']);┌────────────────────────────────────────┐│ arrays_zip([1, 2, 3], ['a', 'b', 'c']) │├────────────────────────────────────────┤│ [(1,'a'),(2,'b'),(3,'c')] │└────────────────────────────────────────┘