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