title: AWS Athena query error when trying to filter by date
body: <p>I am trying to use Athena to query some data I have stored in an s3 bucket in parquet format. I have field called <code>datetime</code> which is defined as a date data type in my AWS Glue Data Catalog.
  <a href="https://i.stack.imgur.com/QEXtP.png" rel="noreferrer"><img src="https://i.stack.imgur.com/QEXtP.png" alt="Image showing schema details in Data Catalog" /></a></p>
  <p>When I try running the following query in Athena, I get the error below:</p>
  <pre><code>SELECT DISTINCT datetime 
  FROM &quot;craigslist&quot;.&quot;pq_craigslist_rental_data_parquet&quot;
  WHERE datetime &gt; '2018-09-14'
  ORDER BY datetime DESC;
  </code></pre>
  <p>And the error:</p>
  <blockquote>
  <p>Your query has the following error(s):</p>
  <p>SYNTAX_ERROR: line 3:16: '&gt;' cannot be applied to date, varchar(10)</p>
  </blockquote>
  <p>What am I doing wrong here? How can I properly filter this data by date?</p>