title: Amazon Athena - Column cannot be resolved on basic SQL WHERE query
body: <p>I am currently evaluating Amazon Athena and Amazon S3.
  I have created a database (testdb) with one table (awsevaluationtable). The table has two columns, x (bigint) and y (bigint). </p>
  
  <p>When I run:</p>
  
  <pre><code>SELECT * 
  FROM testdb."awsevaluationtable"
  </code></pre>
  
  <p>I get all of the test data:
  <a href="https://i.stack.imgur.com/nEevs.png" rel="noreferrer"><img src="https://i.stack.imgur.com/nEevs.png" alt="Successful Query"></a></p>
  
  <p>However, when I try a basic WHERE query:</p>
  
  <pre><code>SELECT * 
  FROM testdb."awsevaluationtable" 
  WHERE x &gt; 5
  </code></pre>
  
  <p>I get:</p>
  
  <pre><code>SYNTAX_ERROR: line 3:7: Column 'x' cannot be resolved
  </code></pre>
  
  <p>I have tried all sorts of variations:</p>
  
  <pre><code>SELECT * FROM testdb.awsevaluationtable WHERE x &gt; 5
  SELECT * FROM awsevaluationtable WHERE x &gt; 5
  SELECT * FROM testdb."awsevaluationtable" WHERE X &gt; 5
  SELECT * FROM testdb."awsevaluationtable" WHERE testdb."awsevaluationtable".x &gt; 5
  SELECT * FROM testdb.awsevaluationtable WHERE awsevaluationtable.x &gt; 5
  </code></pre>
  
  <p>I have also confirmed that the x column exists with:</p>
  
  <pre><code>SHOW COLUMNS IN sctawsevaluation
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/02pVz.png" rel="noreferrer"><img src="https://i.stack.imgur.com/02pVz.png" alt="Column query"></a></p>
  
  <p>This seems like an extremely simple query yet I can't figure out what is wrong. I don't see anything obvious in the <a href="https://docs.aws.amazon.com/athena/latest/ug/select.html" rel="noreferrer">documentation</a>. Any suggestions would be appreciated.</p>