title: HIVE: CREATE TABLE AS SELECT command cannot specify the list of columns for the target table
body: <p>How can I make this work?</p>
  
  <pre><code>  hive&gt; desc temp;
    OK
    a                     int                                         
    b                     int                                         
    Time taken: 0.077 seconds, Fetched: 2 row(s)
  </code></pre>
  
  <p>I want to create t2 HIVE table with column names c and d but getting below error.</p>
  
  <pre><code>  hive&gt; create table t2(c int,d int) as select a,b from temp;
    FAILED: SemanticException [Error 10065]: CREATE TABLE AS SELECT command         cannot specify the list of columns for the target table
  </code></pre>