更新时间:2023-11-25 22:39:52
我会使用 exists
:
SELECT campaign, event_list
FROM `adobe_analytics.raw_data_20200*` rd
WHERE campaign IS NOT NULL AND
EXISTS (SELECT 1
FROM UNNEST(SPLIT(rd.event_list)) el
WHERE el IN ('1', '2', '3')
);