https://cwiki.apache.org/Hive/languagemanual-ddl.html#LanguageManualDDL-Ren ameTable
The link mentions that it changes the directory also. If not you can change the table name and then use "alter table <table name> set location <new location>" Let us know what you see. On 3/7/13 3:29 PM, "Keith Wiley" <[email protected]> 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 [email protected] keithwiley.com >music.keithwiley.com > >"Luminous beings are we, not this crude matter." > -- Yoda >__________________________________________________________________________ >______ >
