title: Hive Dynamic Partition table issue with altering partition
body: <p>I Have table with dynamic partition  "campaign" and static partitions year and month(that means I am giving there value while inserting/creating partitions).</p>
  
  <p>'ABC' Partition by (year='2011', month='08', campaign)</p>
  
  <p>As dynamic partition is only supported when its followed by static partitions namesly year and month. But my use case is opposite  </p>
  
  <p>I want something like this -->
    'ABC' Partition by (campaign, year='2011', month='08')</p>
  
  <p>So that i can see for campaigns results per year and month.</p>
  
  <p>By any chance, OR any other option by which I can do that? something like this??</p>
  
  <p>ALTER TABLE ABC PARTITION (y='2011', m='08',campaign) RENAME/ALTER PARTITIONs (campaign,y='2011', m='08');</p>