...
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 |
...