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=73&rev2=74 -------------------------------------------------- Note that TOUCH doesn't create a table or partition if it doesn't already exist. (See [[Hive/LanguageManual/DDL#Create.2BAC8-Drop_Table|Create Table]]) + + === Alter Table (Un)Archive === + + {{{ + ALTER TABLE table_name ARCHIVE PARTITION partition_spec; + ALTER TABLE table_name UNARCHIVE PARTITION parition_spec; + }}} + + Archiving is a feature to moves a partition's files into a Hadoop Archive (HAR). Note that only the file count will be reduced; HAR does not provide any compression. See [[Hive/LanguageManual/Archiving]] for more information == Create/Drop View == ''Note:'' View support is only available starting in Hive 0.6.
