Dear Wiki user, You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.
The "Hive/LanguageManual/DDL" page has been changed by JohnSichi. http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL?action=diff&rev1=66&rev2=67 -------------------------------------------------- {{{ ALTER TABLE table_name RENAME TO new_table_name }}} - This statement lets you change the name of a table to a different name. '''The location of the data and the names of partitions do not change!''' In other words, the old table name is not "freed," and writing to it will alter the "renamed" table's data! + This statement lets you change the name of a table to a different name. + + As of version 0.6, a rename on a managed table moves its HDFS location as well. (Older Hive versions just renamed the table in the metastore without moving the HDFS location.) === Change Column Name/Type/Position/Comment === {{{
