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