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 PaulYang
Date Thu, 28 Jan 2010 01:20:25 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 PaulYang.
http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL?action=diff&rev1=48&rev2=49

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

  You can use ALTER TABLE ADD PARTITION to add partitions to a table.  Partition values should
be quoted only if they are strings.
  
  {{{
- alter table page_view add partition (dt='2008-08-08', country='us') location '/path/to/us/part080808'
partition (dt='2008-08-09', country='us') location '/path/to/us/part080809';
+ ALTER TABLE page_view ADD PARTITION (dt='2008-08-08', country='us') location '/path/to/us/part080808'
PARTITION (dt='2008-08-09', country='us') location '/path/to/us/part080809';
  }}}
  === Drop Partitions ===
  {{{
@@ -181, +181 @@

  You can use ALTER TABLE DROP PARTITION to drop a partition for a table. This removes the
data and metadata for this partition.
  
  {{{
- alter table page_view drop partition(dt='2008-08-08', country='us');
+ ALTER TABLE page_view DROP PARTITION (dt='2008-08-08', country='us');
  }}}
  === Rename Table ===
  {{{
@@ -195, +195 @@

  }}}
  This command will allow users to change a column's name, data type, comment, or position,
or an arbitrary combination of them.
  
- Example: create table test_change (a int, b int, c int);
+ 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 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 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 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.
  
@@ -234, +234 @@

  
  === Alter Table File Format and Organization ===
  {{{
- ALTER TABLE table_name SET FILE FORMAT file_format
+ ALTER TABLE table_name SET FILEFORMAT file_format
  ALTER TABLE table_name CLUSTERED BY (col_name, col_name, ...) [SORTED BY (col_name, ...)]
INTO num_buckets BUCKETS
  }}}
  These statements change the table's physical storage properties.  For available file_format
options, see the section above on CREATE TABLE.

Mime
View raw message