I found the problem while i run the hive BDR and it took 2 hours.
Cloudera support inform us that's the bug and workaround is to disable
The possible way to work around is to disable the replication of table column statistics but we don't know how?
Anyone has idea?
This slowness is most probably because of a fix (OPSAPS-62843) that was introduced in 7.1.7 SP1 to have a hotfix of a functional error (reported in ENGESC-8654), but having the disadvantage of decline in performance.
The performance decline has already been reported and discussed in several other escalations, e.g. ENGESC-15274.
So the possible ways to go forward with the solution is
---> to wait until the fix for the performance decline (OPSAPS-65104) gets released,
---> or to apply a workaround on the nodes of the target cluster that would disable the replication of table column statistics, but would enhance the performance. For that the file /opt/cloudera/cm-agent/service/dr/chive.sh would have to be modified on each node of the target cluster.