bigfunctions > array_intersect

array_intersect

Signature

array_intersect(array1, array2)

Description

Returns the intersection of two arrays.

Examples

EUUSeurope-west1

select bigfunctions.eu.array_intersect([1, 2, 3], [2, 6, 7])

select bigfunctions.us.array_intersect([1, 2, 3], [2, 6, 7])

select bigfunctions.europe_west1.array_intersect([1, 2, 3], [2, 6, 7])

+--------+
| result |
+--------+
| [2]    |
+--------+