Re: Error while renaming Partitioned column name

2014-07-09 Thread D K
=str_date} >> >> >> >> Am I missing something here? >> >> >> >> Thanks, >> >> Manish >> >> >> >> >> >> *From:* D K [mailto:deepe...@gmail.com] >> *Sent:* Wednesday, July 09, 2014 12:38 PM >&

Re: Error while renaming Partitioned column name

2014-07-09 Thread Nitin Pawar
ition 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

2014-07-09 Thread Manish Kothari
LED: 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

Re: Error while renaming Partitioned column name

2014-07-09 Thread D K
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 wrote: > Hi, > > > > I have a table name siplogs_partitioned which is partitioned

Error while renaming Partitioned column name

2014-07-09 Thread Manish Kothari
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_