title: How do I use columns I just created to create another column in Impala?
body: <p>I'm trying to figure out how to create a column based on other columns I just created. This is what I'm trying: </p>
  
  <pre><code>CREATE TABLE test AS 
  (SELECT 
  1 as column_1,
  2 as column_2,
  column_1 + column_2 as column_3
  ) 
  </code></pre>
  
  <p>But I get this error, </p>
  
  <blockquote>
    <p>AnalysisException: Could not resolve column/field reference: 'column_1'</p>
  </blockquote>
  
  <p>I'm using HUE and Impala.</p>