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 Mon, 01 Mar 2010 23:31:59 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=50&rev2=51

--------------------------------------------------

  
  Example: CREATE TABLE test_change (a int, b int, c int);
  
- "ALTER TABLE CHANGE a a1 INT;" will change column a's name to a1.
+ "ALTER TABLE test_change CHANGE a a1 INT;" will change column a's name to a1.
  
- "ALTER TABLE CHANGE a a1 STRING AFTER b;" will change column a's name to a1, a's data type
to string, and put it after column b. The new table's structure is: b int, a1 string, c int.
+ "ALTER TABLE test_change CHANGE a a1 STRING AFTER b;" will change column a's name to a1,
a's data type to string, and put it after column b. The new table's structure is: b int, a1
string, c int.
  
- "ALTER TABLE CHANGE b b1 INT FIRST;" will change column b's name to b1, and put it as the
first column. The new table's structure is: b1 int, a string, c int.
+ "ALTER TABLE test_change CHANGE b b1 INT FIRST;" will change column b's name to b1, and
put it as the first column. The new table's structure is: b1 int, a string, c int.
  
  NOTE: The column change command will only modify Hive's metadata, and will NOT touch data.
Users should make sure the actual data layout conforms with the metadata definition.
  

Mime
View raw message