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:34:54 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.
http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL?action=diff&rev1=76&rev2=77

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

  == 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 index_name 
+ ON TABLE base_table_name (col_name, ...)
+ AS index_type
+ [ WITH DEFERRED REBUILD ]
+ [ IDXPROPERTIES (property_name=property_value, ...) ]
+ [ IN TABLE index_table_name ]
+ [ PARTITIONED BY (col_name, ...) ]
+ [
+    [ ROW FORMAT ... ] STORED AS ...
+    | STORED BY ...
+ ]
+ [ LOCATION hdfs_path ]
+ [ TBLPROPERTIES (...) ]
+ [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
+ 
+ CREATE INDEX creates an index on a table using the given list of columns as keys.  See http://wiki.apache.org/hadoop/Hive/IndexDev#CREATE_INDEX
  
  === Drop Index ===
  {{{

Mime
View raw message