View metadata

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.

Command	Action
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