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 MarcelKornacker
Date Tue, 28 Dec 2010 22:18:28 GMT
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 MarcelKornacker.
http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL?action=diff&rev1=80&rev2=81

--------------------------------------------------

  
  === Drop Partitions ===
  {{{
- ALTER TABLE table_name DROP partition_spec, partition_spec,...
+ ALTER TABLE table_name DROP [IF EXISTS] partition_spec, partition_spec,...
  }}}
  You can use ALTER TABLE DROP PARTITION to drop a partition for a table. This removes the
data and metadata for this partition.
+ 
+ In Hive 0.70 or later, DROP returns an error if the partition doesn't exist, unless IF EXISTS
is specified or the configuration variable hive.exec.drop.ignorenonexistent is set to true.
  
  {{{
  ALTER TABLE page_view DROP PARTITION (dt='2008-08-08', country='us');
@@ -334, +336 @@

  === Drop View ===
  
  {{{
- DROP VIEW view_name
+ DROP VIEW [IF EXISTS] view_name
  }}}
  
  DROP VIEW removes metadata for the specified view.  (It is illegal to use DROP TABLE on
a view.)
  
  When dropping a view referenced by other views, no warning is given (the dependent views
are left dangling as invalid and must be dropped or recreated by the user).
+ 
+ In Hive 0.70 or later, DROP returns an error if the view doesn't exist, unless IF EXISTS
is specified or the configuration variable hive.exec.drop.ignorenonexistent is set to true.
  
  Example:
  
@@ -369, +373 @@

  You can unregister a UDF as follows:
  
  {{{
- DROP TEMPORARY FUNCTION function_name
+ DROP TEMPORARY FUNCTION [IF EXISTS] function_name
  }}}
+ 
+ In Hive 0.70 or later, DROP returns an error if the function doesn't exist, unless IF EXISTS
is specified or the configuration variable hive.exec.drop.ignorenonexistent is set to true.
  
  == Create/Drop Index ==
  Not available until 0.7 release
@@ -396, +402 @@

  
  === Drop Index ===
  {{{
- DROP INDEX index_name ON table_name
+ DROP INDEX [IF EXISTS] index_name ON table_name
  }}}
  DROP INDEX drops the index, as well as deleting the index table.
  
+ In Hive 0.70 or later, DROP returns an error if the index doesn't exist, unless IF EXISTS
is specified or the configuration variable hive.exec.drop.ignorenonexistent is set to true.
  
  == Show/Describe Statements ==
  These statements provide a way to query the Hive metastore for existing data and metadata
accessible to this Hive system.

Mime
View raw message