Re: Renaming partition columnname only (locations remain unchanged)

2013-06-12 Thread Sanjay Subramanian
Alter table rename partition column does not recognize the column name. It's ok I dropped the table and created a new one and executed ADD PARTITION. and provided LOCATION Sanjay Sent from my iPhone On Jun 12, 2013, at 9:53 AM, "Stephen Sprague" mailto:sprag...@gmail.com>> wrote: all you have

Re: Renaming partition columnname only (locations remain unchanged)

2013-06-12 Thread Stephen Sprague
all you have to do is create a partitioned test table and run an alter table command to rename the partition column(s) - and see what happens. That's about as simple as it gets. It either works or it doesn't. :) On Tue, Jun 11, 2013 at 9:50 PM, Nitin Pawar wrote: > currently hive partitions on

Re: Renaming partition columnname only (locations remain unchanged)

2013-06-11 Thread Nitin Pawar
currently hive partitions on hdfs stored as col1=val1/col2=val2 looking at this if you change the column name in the metadata, I am not sure you will be able to locate the data with old column name. other way would be alter table and and run hdfs move to reflect your new column name in the partiti

Renaming partition columnname only (locations remain unchanged)

2013-06-11 Thread Sanjay Subramanian
Hi I have external tables where I want to change the name of the partition column, locations remaining constant Is there a way to do this…Else I will drop and create the table with new partition column names and run my scripts to ADD PARTITION, with LOCATION specified Thanks sanjay CONFIDENTIAL