Cloudera Docs

Verifying actual Hive data migration

After running the DistCp to migrate Hive data from HDP to Cloudera, you take a look at the migrated data on the Cloudera cluster.

  1. From a JDBC client, such as DBeaver, create a connection to the Cloudera cluster.
  2. Generate a passcode token to connect to the Cloudera cluster.
  3. Run SQL SELECT queries and check the output to verify that the external table data is migrated.
    For example:
    SELECT * FROM migrate_db.external_table_1;
  4. Run SELECT queries and check the output to verify that managed data is migrated. 
    SELECT * FROM migrate_db.managed_table_3;