whats your table DDL?
On Wed, Jul 9, 2014 at 11:03 PM, Manish Kothari <manish.koth...@vonage.com>
wrote:
> Thanks Dipesh.
>
>
>
> Here is what I tried : -
>
>
>
> ALTER TABLE siplogs_partitioned PARTITION
> (pcol1='str_hour',pcol2='str_date') RENAME TO PARTITION
> (pcol1='call_hour',pcol2='call_date');
>
>
>
> When I run the above command I am getting the error below : -
>
>
>
> FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask. str_date not found in table's
> partition spec: {pcol1=str_hour, pcol2=str_date}
>
>
>
> Am I missing something here?
>
>
>
> Thanks,
>
> Manish
>
>
>
>
>
> *From:* D K [mailto:deepe...@gmail.com]
> *Sent:* Wednesday, July 09, 2014 12:38 PM
> *To:* user@hive.apache.org
> *Subject:* Re: Error while renaming Partitioned column name
>
>
>
> 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
>
>
>
--
Nitin Pawar
