title: Rename partition and set new location hive
body: <p>Need to rename partition and set the new location for an external table all in one statement.</p>
  
  <pre class="lang-sql prettyprint-override"><code>alter table A partition(part='A') rename to partition (part='B');
  alter table A partition(part='B') set location 's3://...';
  </code></pre>
  
  <p>I am trying to see if this can be combined in to single statement </p>
  
  <pre class="lang-sql prettyprint-override"><code>alter table A partition(part='A') rename to partition(part='B') set location 's3://'..'
  </code></pre>