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. http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL?action=diff&rev1=74&rev2=75 -------------------------------------------------- }}} 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]
