title: How to delete multiple partitions in HIVE table
body: <p>I would like to delete multiple partitions in Hive table. I am able to delete specific partition using ALTER statement as follow :</p>
  
  <pre><code>ALTER TABLE table_name DROP IF EXISTS PARTITION (partition_col= val)
  </code></pre>
  
  <p>But it is not working with operators like <code>&gt;</code> or <code>&lt;</code>.</p>
  
  <p>The error thrown is :</p>
  
  <pre><code>mismatched input '&lt;' expecting {')', ','}(line 1, pos 81)
  </code></pre>