Q: In bigquery how can I check if at least one elemnt from one array is in another array? 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?
