THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
| Code Block |
|---|
SHOW TABLES identifier_with_wildcards;
|
SHOW TABLES lists all the base tables and views with names matching the given regular expression. Regular expression can contain only '' for any characters or '|' for a choice. Examples are 'page_view', 'page_v', 'view|page', all which will match 'page_view' table. Matching tables are listed in alphabetical order. It is not an error if there are no matching tables found in metastore.
Show Table Properties
| Info | ||
|---|---|---|
| ||
As of Hive 0.10.0 |
| Code Block |
|---|
SHOW TBLPROPERTIES tblname;
SHOW TBLPROPERTIES tblname("foo");
|
The first form lists all of the table properties for the table in question one per row separated by tabs. The second form of the command prints only the value for the property that's being asked for.
Show Partitions
| Code Block |
|---|
SHOW PARTITIONS table_name |
...