google bigquery selecting rows with multiple values in repeating field
<p>Lets say I have a schema: 
key STRING  NULLABLE<br>
values  INTEGER REPEATED</p>

<p>Now, please note that second column is a repeated field of integers, </p>

<p>Lets say the data is something like:</p>

<p>key:'abc' 
values: 1 2 3    (3 separate values, same for below values)</p>

<p>key:'def' 
values: 1 2 5</p>

<p>key:'ghi'
values: 1 6 9</p>

<p>And here I wish to find out keys which has values 1 and 2 ? Expecting 'abc' and 'def' as result set. </p>

<p>Looking for a query for this. I want an 'and' ('in' does not work here). I need those both values to be present for any key to return as result. </p>