title: dropping hive partition dynamically
body: <p>I have an HIVE table with daily partitions day wise, something like below (which includes future date's partition as well)</p>
  
  <pre><code>20160901
  20160902
  ........
  ........
  ........
  20160931
  20161001
  20161002
  </code></pre>
  
  <p>I want to pass one date say for example yesterday's date 20160922 and want to drop all partitions dynamically which are >= 20160922 (though today is 20160923, but I want to drop from 20160922 date).</p>
  
  <p>How can I can drop all these partitions dynamically.</p>