hadoop-common-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Hadoop Wiki] Update of "Hive/LanguageManual/DDL" by JohnSichi
Date Sat, 17 Jul 2010 17:43:43 GMT
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 ===
  {{{

Mime
View raw message