title: DDL error in Create table statement of Big Query
body: <p>I am getting "Cannot set destination table in jobs with DDL statements" error while creating a table in Big Query. How to resolve this?</p>
  
  <pre class="lang-sql prettyprint-override"><code>create table `decent-fulcrum-254016.4thOct_LR.NewData_Train` 
  as 
  (
    SELECT * 
    FROM `decent-fulcrum-254016.4thOct_LR.NewData` 
    order by rand() LIMIT 700000
  )
  </code></pre>