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.
|