title: BigQuery STRUCT Syntax
body: <p>Given following struct structure. In below leaf node is <code>field1</code>, <code>field2</code> the rest are object structure containing the leaf. </p>
  
  <pre><code>dimension1.dimension2.dimension3.field1
  dimension1.dimension2.dimension3.field2
  dimension1.dimension2.field1
  dimension2.dimension2.field2
  dimension1.field1
  </code></pre>
  
  <p>Q1. How do I rename field2 from both <code>dimension1.dimension2.dimension3.field2</code> and <code>dimension2.dimension2.field2</code> while maintaining rest of the structure? I found example to replace one level of nested struct but unable to do this for nested struct. </p>
  
  <p>Q2. The leaf name <code>field1</code> appears in different struct locations. When I attempt to perform select statement such as below I am getting error messages saying duplicate name is not supported. I'm not sure how is below duplicate as paths for all fields are different. How can I get around this issue?</p>
  
  <pre><code>     SELECT dimension1.dimension2.dimension3.field1
       dimension1.dimension2.field1
       dimension1.field1
  </code></pre>