title: BigQuery union over nested fields
body: <p>I'm trying to create a union of 3 tables. All 3 tables are subselects on the same table: each subselect contains only one field, with the same alias to the field on all subselects, so the resulting schema will be compatible and the union will succeed (following the example from <a href="https://stackoverflow.com/questions/10644993/support-union-function-in-bigquery-sql">Support UNION function in BigQuery SQL</a>).</p>
  
  <p>The resulting query yields an error:</p>
  
  <blockquote>
    <p>Union results in ambiguous schema. [foo] is ambiguous and is aliasing multiple fields. Aliased fields: ...</p>
  </blockquote>
  
  <p>It may be that there error is related to the fact the field I select is a nested in multiple records and repeated fields.</p>
  
  <p>Fictitious Query example:</p>
  
  <blockquote>
    <p>select * from <br/>
    (SELECT record.list1.list2.listA.foo as foo from sample),<br/>
    (SELECT record.list1.list2.listB.foo as foo from sample),<br/>
    (SELECT record.list1.list2.listC.foo as foo from sample)<br/></p>
  </blockquote>
  
  <p>See job job_eZm0F1cGA2leE37D8-N5NHNTTYU for a concrete example (this is a table that contains data I cannot share).</p>