📣
TiDB Cloud Premium is now in public preview. Unlimited growth, instant elasticity, advanced security for enterprise workloads. Try it out →

ARRAYS_ZIP



Merges multiple arrays into a single array tuple.

Syntax

ARRAYS_ZIP( <array1> [, ...] )

Arguments

ArgumentsDescription
<arrayN>The input ARRAYs.

Return Type

Array(Tuple).

Examples

SELECT ARRAYS_ZIP([1, 2, 3], ['a', 'b', 'c']); ┌────────────────────────────────────────┐ │ arrays_zip([1, 2, 3], ['a', 'b', 'c']) │ ├────────────────────────────────────────┤ │ [(1,'a'),(2,'b'),(3,'c')] │ └────────────────────────────────────────┘

Was this page helpful?