title: Insert query on Partitioned tables in Bigquery
body: <p>I have some Insert queries written in hive to be migrated in Bigquery. 
  For example: </p>
  
  <pre><code>insert into test.abc partition(yrmth) select * from test.xyz
  </code></pre>
  
  <p>In Bigquery, partition is only supported in <code>YYYYMMDD</code> format. I'm able to dump the data in partitioned table through BQ command line tool by loading <code>test.abc$20171125</code>.</p>
  
  <p>How can I achieve the same using DML statements in Bigquery? </p>
  
  <p>I have learnt that Legacy SQL doesn't support writing DML statements and Standard SQL doesn't support the table specifications like <code>test.abc$20171125</code> that is required for loading the data in corresponding partition.</p>