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.
