Skip to main content
Version: 2.3

View metadata

Use the Data Migrator 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 confShow the configured value of a particular property
hive show databaseShow details of a database
hive show databasesShow a list of databases
hive show indexesShow a list of indexes from a specific database/table
hive show partitionsShow a list of partitions from a specific database/table
hive show tableShow details of a table from a database
hive show tablesShow a list of tables from a database