title: BigQuery: Select REPEATED fields as REPEATED fields
body: <p>I'm loading data into BigQuery via Avro, one of my columns is an Array. That appears to load ok, however, because BigQuery appends root as a prefix to the column names, I need to select all the columns into their appropriate names. I have included the --noflatten_results flag but the query fails with "Cannot create valid output schema for field order_ids. Try renaming order_ids to root.order_ids in the outermost SELECT"</p>
  
  <p>Query:</p>
  
  <pre><code>SELECT
  root.a AS a,
  root.b AS b,
  root.orders_ids AS order_ids,
  root.c AS c,
  root.d AS d 
  FROM dataset.table
  </code></pre>