Here is an example: ALTER TABLE alter_rename_partition PARTITION (pCol1='old_part1', pcol2='old_part2') RENAME TO PARTITION (pCol1='new_part1', pcol2='new_part2');
On Wed, Jul 9, 2014 at 9:20 AM, Manish Kothari <manish.koth...@vonage.com> wrote: > Hi, > > > > I have a table name siplogs_partitioned which is partitioned by columns > str_date(DATE) and str_hour(INT). I want to rename the partitioned columns > to call_date and call_hour. > > > > I am using the below command to alter the partitioned column name: - > > > > ALTER TABLE siplogs_partitioned PARTITION str_date RENAME TO PARTITION > call_date; > > > > When I run the above command I am getting an error : - > > > > FAILED: ParseException line 1:12 cannot recognize input near > 'siplogs_partitioned' 'PARTITION' 'str_date' in alter table partition > statement > > > > Is the “ALTER TABLE” usage correct to rename the partitioned column names? > > > > Any pointer or help is appreciated. > > > > Thanks, > > Manish >
