title: AWS Athena: Delete partitions between date range
body: <p>I have an athena table with partition based on date like this:</p>
  
  <pre><code>20190218
  </code></pre>
  
  <p>I want to delete all the partitions that are created last year.</p>
  
  <p>I tried the below query, but it didnt work.</p>
  
  <pre><code>ALTER TABLE tblname DROP PARTITION (partition1 &lt; '20181231');
  
  ALTER TABLE tblname DROP PARTITION (partition1 &gt; '20181010'), Partition (partition1 &lt; '20181231');
  </code></pre>