THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
SHOW COLUMNS shows all the columns in a table including partition columns.
Show Create Table
| Info | ||
|---|---|---|
| ||
As of Hive 0.10 |
| Code Block |
|---|
SHOW CREATE TABLE ([db_name.]table_name|view_name)
|
SHOW CREATE TABLE shows the CREATE TABLE statement that creates a given table, or the CREATE VIEW statement that creates a given view.
Describe Database
| Code Block |
|---|
DESCRIBE DATABASE db_name |
...