THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
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.
Show Columns
| Info | ||
|---|---|---|
| ||
As of Hive 0.10 |
| Code Block |
|---|
SHOW COLUMNS (FROM|IN) table_name [(FROM|IN db_name]
|
SHOW COLUMNS shows all the columns in a table including partition columns.
Describe Database
| Code Block |
|---|
DESCRIBE DATABASE db_name |
...