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 === {{{
