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 Fri, 19 Nov 2010 23:28:07 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=78&rev2=79

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

  }}}
  
  == Create/Drop Index ==
+ Not available until 0.7 release
  === Create Index ===
  {{{
  CREATE INDEX index_name 
@@ -437, +438 @@

  {{{
  SHOW [FORMATTED] (INDEX|INDEXES) ON table_with_index [(FROM|IN) db_name]
  }}}
- SHOW INDEXES shows all of the indexes on a certain column, as well as information about
them: index name, table name, names of the columns used as keys, index table name, index type,
and comment.  If the FORMATTED keyword is used, then column titles are printed for each column.
+ SHOW INDEXES shows all of the indexes on a certain column, as well as information about
them: index name, table name, names of the columns used as keys, index table name, index type,
and comment.  If the FORMATTED keyword is used, then column titles are printed for each column.
 Not available until 0.7 release.
  
  === Describe Table/Column ===
  {{{

Mime
View raw message