GROUP_ARRAY_INTERSECT
更新时间：2025-10-16
描述
求出所有行中输入数组中的交集元素，返回一个新的数组
语法
SQL
1GROUP_ARRAY_INTERSECT(<expr>)参数
| 参数 | 说明 |
|---|---|
<expr> |
需要求交集的数组列或数组值 |
返回值
返回一个包含交集结果的数组
举例
SQL
1select c_array_string from group_array_intersect_test where id in (18, 20);
Text
1+------+---------------------------+
2| id | col |
3+------+---------------------------+
4| 1 | ["a", "b", "c", "d", "e"] |
5| 2 | ["a", "b"] |
6| 3 | ["a", null] |
7+------+---------------------------+
SQL
1select group_array_intersect(col) from group_array_intersect_test;
Text
1+----------------------------+
2| group_array_intersect(col) |
3+----------------------------+
4| ["a"] |
5+----------------------------+