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:12:14 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.


  SHOW FUNCTIONS lists all the user defined and builtin functions matching the regular expression.
To get all functions use ".*"
+ === Show Indexes ===
+ {{{
+ 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.
  === Describe Table/Column ===
  DESCRIBE [EXTENDED] table_name[DOT col_name]

View raw message