hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stephen Sprague <>
Subject Re: Renaming partition columnname only (locations remain unchanged)
Date Wed, 12 Jun 2013 16:52:00 GMT
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 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 partition directories on hdfs.
> It looks much simpler to just create new table and dump the old one via
> hive though
> On Wed, Jun 12, 2013 at 3:46 AM, Sanjay Subramanian <
>> wrote:
>>    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
>> ======================
>> This email message and any attachments are for the exclusive use of the
>> intended recipient(s) and may contain confidential and privileged
>> information. Any unauthorized review, use, disclosure or distribution is
>> prohibited. If you are not the intended recipient, please contact the
>> sender by reply email and destroy all copies of the original message along
>> with any attachments, from your computer system. If you are the intended
>> recipient, please be advised that the content of this message is subject to
>> access, review and disclosure by the sender's Email System Administrator.
> --
> Nitin Pawar

View raw message