title: Google BigQuery - nested fields or table join
body: <ol>
  <li><p>In Google BigQuery [1], it support nested field type, so can I say that it is preferred way to organize than splitting into tables and query with join?</p></li>
  <li><p>Bigquery support patch when we need to add a new columns, how is the performance when adding new column in a very large table, e.g. 1TB, are there any way to min. down time since we might need to update columns a few time a month.</p></li>
  </ol>
  
  <p>[1] <a href="https://developers.google.com/bigquery/docs/data#nested" rel="nofollow">https://developers.google.com/bigquery/docs/data#nested</a></p>
  
  <p>[2] <a href="https://developers.google.com/bigquery/docs/reference/v2/tables/patch" rel="nofollow">https://developers.google.com/bigquery/docs/reference/v2/tables/patch</a></p>