Verifying metadata migration

After running the HMS Mirror tool to migrate Hive metadata from HDP to CDP, you take a look at the migrated metadata on the CDP cluster.

  1. From a JDBC client, such as DBeaver, create a connection to the CDP cluster.
  2. Generate a passcode token to connect to the CDP cluster.
  3. Run SQL queries and check the output to verify that the databases and tables are migrated.
    For example:
    USE migrate_db;