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 HeYongqiang
Date Wed, 11 Aug 2010 17:31:54 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 HeYongqiang.
http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL?action=diff&rev1=70&rev2=71

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

  
  === Alter Table File Format and Organization ===
  {{{
- ALTER TABLE table_name SET FILEFORMAT file_format
+ ALTER TABLE table_name [partitionSpec] 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.
  
+ Alter file format can also apply on a partition.
+ 
  NOTE: These commands will only modify Hive's metadata, and will NOT reorganize or reformat
existing data. Users should make sure the actual data layout conforms with the metadata definition.
+ 
+ === Alter Table/Partition Location ===
+ {{{
+ ALTER TABLE table_name [partitionSpec] SET LOCATION "new location"
+ }}}
  
  === Alter Table Touch ===
  {{{

Mime
View raw message