title: Create external table with select from other table
body: <p>I am using HDInsight and need to delete my clusters when I am finished running queries. However, I need the data I gather to survive for another day. I am working on queries that would create calculated columns from table1 and insert them into table2. First I wanted a simple test to copy the rows. Can you create an external table from a select statement?  </p>
  
  <pre><code>drop table if exists table2;
  
  create external table table2 as
  select *  
  from table1
  STORED AS TEXTFILE LOCATION 'wasb://{container name}@{storage name}.blob.core.windows.net/';
  </code></pre>