How to rename partition value in Hive?
<p>I have a hive table 'videotracking_playevent' which uses the following partition format (all strings): source/createyear/createmonth/createday. 
Example: source=home/createyear=2016/createmonth=9/createday=1</p>

<p>I'm trying to update the partition values of createmonth and createday to consistently use double digits instead.
Example: source=home/createyear=2016/createmonth=09/createday=01</p>

<p>I've tried to the following query:</p>

<pre><code>ALTER TABLE videotracking_playevent PARTITION (
source='home', 
createyear='2015', 
createmonth='11', 
createday='1'
) RENAME TO PARTITION (
source='home', 
createyear='2015', 
createmonth='11', 
createday='01'
);
</code></pre>

<p>However that returns the following, non-descriptive error from hive: <code>Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. null</code></p>

<p>I've confirmed that this partition exists, and I think I'm using the correct syntax. My hive version is Hive 1.1.0
Any ideas what I might be doing wrong?</p>