hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dean Wampler <>
Subject Re: Rename external table, including HDFS directory
Date Fri, 08 Mar 2013 00:02:09 GMT
You can rename the LOCATION with an ALTER TABLE command. I don't believe
there's a single, "atomic" statement to rename both the table and the

On Thu, Mar 7, 2013 at 5:29 PM, Keith Wiley <> wrote:

> My understanding is that renaming and external table doesn't rename the
> corresponding HDFS directory to match.  I would like to do this; I want to
> rename the table in Hive and also rename the HDFS directory so they match
> (they already match with the old name).  I'm not sure how to do this.  I'm
> worried that if I rename the HDFS directory through Hadoop, not Hive, that
> Hive will lose track of the directory, regardless of whether I rename the
> table in Hive as well.
> I also don't want to drop and recreate the table because I don't want to
> notify Hive of all the partitions all over again.
> Thoughts?
> ________________________________________________________________________________
> Keith Wiley
> "Luminous beings are we, not this crude matter."
>                                            --  Yoda
> ________________________________________________________________________________

*Dean Wampler, Ph.D.*

View raw message