Dear Wiki user, You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.
The following page has been changed by PrasadChakka: http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL ------------------------------------------------------------------------------ === Drop Partitions === {{{ - ALTER TABLE DROP partition_spec, partition_spec,... + ALTER TABLE table_name DROP partition_spec, partition_spec,... partition_spec: : PARTITION (partition_col = partition_col_value, partition_col = partiton_col_value, ...) }}} - You can use ALTER TABLE DROP PARTITION to drop a partition for a table. This removes the data and metadata for this partition. + You can use ALTER TABLE DROP PARTITION to drop a partition for a table. This removes the data and metadata for this partition. Partition value should be quoted only if it is a string. + + {{{ + alter table page_view drop partition(dt='2008-08-08', country='us') + }}} == Alter Table Statements == Alter table statements enable you to change the structure of an existing table. You can add columns, change serde, add table and serde properties, or rename the table itself.
