hadoop-common-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Hadoop Wiki] Update of "Hive/LanguageManual/DDL" by PrasadChakka
Date Tue, 10 Feb 2009 02:43:22 GMT
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.

Mime
View raw message