In bigquery how can I check if at least one elemnt from one array is in another array?

Viewed 23

I have two arrays. lets call them arr1 and arr2. what I want to do is to find all the rows with the following condition: if at least one element from arr1 is in arr2 I want to get this row

Any ideas? Maybe with left join?

0 Answers
Related