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 RussellMelick
Date Wed, 17 Nov 2010 06:29:22 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 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.
  

Mime
View raw message