Verifying the Hive data replication from HDP 3.1.5 to 7.1.6

After replicating Hive databases from HDP 3.1.5 (with patches) to CDP 7.1.6 (with patches) you need to verify that the replication succeeded. After verification that databases on both clusters are in sync, you can stop running workloads on the HDP cluster and restart workloads on the CDP cluster.

To verify the replication, follow steps to stop ETL jobs and set up Ranger policies on HDP. Disable HDP background threads, and get an event marker for validation later. Finally, you validate the replication, or handle possible replication failures. The following diagram shows the replication and verification process.