standardSQL

SELECt ipFROM yourTable WHERe (  SELECt COUNT(1)   FROM UNNEST(cookie) AS pair   WHERe pair IN (('grape', 'purple'),  ('orange', 'orange'))) >= 2

您可以使用下面的虚拟数据进行测试

#standardSQLWITH yourTable AS (  SELECt '192.168.1.1' AS ip, [('apple', 'red'), ('orange', 'orange'), ('grape', 'purple')] AS cookie UNIOn ALL  SELECT '192.168.1.2', [('abc', 'xyz')])SELECT ipFROM yourTable WHERe (  SELECt COUNT(1)   FROM UNNEST(cookie) AS pair   WHERe pair IN (('grape', 'purple'),  ('orange', 'orange'))) >= 2

如果在阵列中至少有一对时需要输出ip，则需要更改

>= 2

>=1

WHERe