title: Does unnest always display data in ascending order of hit number in Bigquery
body: <p>I have some data in Bigquery with the following columns</p>
  
  <pre><code>ID    StartTime    HitLevelData
  </code></pre>
  
  <p>My Question is if I want to select data in ascending order of StartTime I can write</p>
  
  <pre><code>Select * FROM MY_TABLE ORDER BY StartTime   
  </code></pre>
  
  <p>But if I want to unnest HitLevel Data in my table and display in ascending order of hitnumber do I need to ORDER BY HITS.HITNUMBER </p>
  
  <pre><code> Select ID, STARTTIME, HITS.HITNUMBER FROM MY_TABLE, UNNEST(HITS) HTIS ORDER BY STARTTIME, HITS.HITNUMBER
  </code></pre>
  
  <p>or I can just do </p>
  
  <pre><code>   Select ID, STARTTIME, HITS.HITNUMBER FROM MY_TABLE, UNNEST(HITS) HTIS ORDER BY STARTTIME
  </code></pre>
  
  <p>I am not sure if unnest by default always display data in ascending order of hitnumber or do I need to specifically write an order by clause for it.</p>
  
  <p>Thanks in advance!</p>