title: How to use filter conditions on SHOW PARTITIONS clause on hive?
body: <p>I am having hive table which is partitioned by date, app_name, src (3 partitions)</p>
  
  <p>I want to fire show partitions command in multiple ways like following</p>
  
  <pre><code>// works
  show partitions mydb.tab_dt partition(date='2017-05-01');
  
  // works
  show partitions mydb.tab_dt partition(date='2017-05-01'/app_name='app_io'/src='mobile');
  </code></pre>
  
  <p>When I need to do some filtering in partition clause i am not able to make it work. examples of some of the things I am trying are below.</p>
  
  <pre><code>// doesn't work
  show partitions mydb.tab_dt partition(date&gt;='2017-05-01');
  
  // doesn't work
  show partitions mydb.tab_dt partition(date='2017-05-01'/app_name like '%app%');
  
  // doesn't work
  show partitions mydb.tab_dt partition(app_name like '%app%'/src='mobile');
  </code></pre>
  
  <p>I hope I have made my question clear.</p>