title: Dropping a range of partitions in HIVE
body: <p>I have a Hive (ver 0.11.0) table partitioned by column date, of type string. I want to know if there exists a way in Hive by which I can drop partitions for a range of dates (say from 'date1' to 'date2'). I have tried the following (SQL type) queries, but they don't seem to be syntactically correct:</p>
  
  <pre><code>ALTER TABLE myTable DROP IF EXISTS PARTITION
  (date&gt;='date1' and date&lt;='date2');
  
  ALTER TABLE myTable DROP IF EXISTS PARTITION
  (date&gt;='date1' &amp;&amp; date&lt;='date2');
  
  ALTER TABLE myTable DROP IF EXISTS PARTITION
  (date between 'date1' and 'date2');
  </code></pre>