arrays_zip

arrays_zip

arrays_zip介绍

arrays_zip(a1, a2, ...) - 返回一个合并后的数组,其中包含结构体(structs),每个结构体包含输入数组中第 N 个值的所有组合。

Examples:

> SELECT arrays_zip(array(1, 2, 3), array(2, 3, 4));
 [{"0":1,"1":2},{"0":2,"1":3},{"0":3,"1":4}]
> SELECT arrays_zip(array(1, 2), array(2, 3), array(3, 4));
 [{"0":1,"1":2,"2":3},{"0":2,"1":3,"2":4}]

Since: 2.4.0