title: How do i filter rows in bigquery, where a nested repeated field contains certain value?
body: <p>Lets assume the nested repeated field is Experience.Company, Experience.Months.
  Now if the Experience record contains , say, "GE" in Experience.Company, i want to skip the entire record.</p>
  
  <p>The query i tried is something of this sort:</p>
  
  <pre><code>select name, location from table_name where Experience.Company != "GE".
  </code></pre>
  
  <p>This obviously doesn't work, since i get the record for other values.</p>
  
  <p>I tried OMIT IF, with the same result.</p>
  
  <p>Anything else I could try?</p>