title: Hadoop SQL - Impala and a calculated field
body: <p>I am very new to Hadoop and attempting to use a "calculated" field as one would in SQL: </p>
  
  <pre><code>SELECT "one" as test, 
      CASE WHEN calculated test = "one" then "This works"
      else "Nope" 
      end as checker
  </code></pre>
  
  <p>But it appears this generates an error:</p>
  
  <blockquote>
    <p>AnalysisException: Syntax error in line 1: ...est, CASE WHEN
    calculated test = "one" then "This work... ^ Encountered: IDENTIFIER
    Expected: AND, BETWEEN, DIV, ILIKE, IN, IREGEXP, IS, LIKE, NOT, OR,
    REGEXP, RLIKE, THEN CAUSED BY: Exception: Syntax error</p>
  </blockquote>
  
  <p>Is it not possible to use a "calculated" field in Hadoop? If so, what am I doing wrong? Apologies if I am missing something obvious, again, new to Hadoop. </p>