Use the WANdisco CLI to view your metadata such as databases, tables, and partitions. You can also view values for configuration properties of your metastore distribution.
Define the agent name in each command to connect to the metastore that you want to query.
hive show conf
|Show the configured value of a particular property
hive show database
|Show details of a database
hive show databases
|Show a list of databases
hive show indexes
|Show a list of indexes from a specific database/table
hive show partitions
|Show a list of partitions from a specific database/table
hive show table
|Show details of a table from a database
hive show tables
|Show a list of tables from a database