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