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 RussellMelick. The comment on this change is: HIVE-1497 and HIVE-1498. http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL?action=diff&rev1=75&rev2=76 -------------------------------------------------- {{{ DROP TEMPORARY FUNCTION function_name }}} + + == Create/Drop Index + === Create Index === + {{{ + CREATE INDEX index_name ON TABLE table_name(column_name1, ...) AS index_type [WITH DEFERRED REBUILD] [IDXPROPERTIES ("prop1"="val1", ...)] ... [COMMENT "index comment"] + }}} + CREATE INDEX creates an index on a table using the given list of columns as keys. Currently, the only index_type is "COMPACT", WITH DEFERRED REBUILD is the only way to actually create an index + + === Drop Index === + {{{ + DROP INDEX index_name ON table_name + }}} + DROP INDEX drops the index, as well as deleting the index table. + + == Show/Describe Statements == These statements provide a way to query the Hive metastore for existing data and metadata accessible to this Hive system.