Skip to main content
Daggers
Daggers
Silver ⭐️⭐️⭐️
July 14, 2019
Solved

Do table statistics get replicated as part of hive BDR replication

Do table statistics get replicated as part of hive BDR replication ?

lwang
lwangAnswer
Platinum ⭐️
July 16, 2019

Hi @Daggers ,

 

Based on the public doc here:

https://www.cloudera.com/documentation/enterprise/release-notes/topics/cm_rn_new_changed_features.html

 

It says:

Table and partition-level column statistics stored in the Hive metastore and used by Impala are now replicated during Hive Replication. This is supported between a replication source with Cloudera Manager running version 5.10 or higher and a replication target running Cloudera Manager 5.10 or higher. Because this change replicates more information, the same schedule may take more time to complete if column statistics are present.

 

Thanks and hope this helps.

Li

Li Wang, Technical Solution Manager
View in thread

3 replies

lwang
Platinum ⭐️
lwangAnswer
Platinum ⭐️
July 16, 2019

Hi @Daggers ,

 

Based on the public doc here:

https://www.cloudera.com/documentation/enterprise/release-notes/topics/cm_rn_new_changed_features.html

 

It says:

Table and partition-level column statistics stored in the Hive metastore and used by Impala are now replicated during Hive Replication. This is supported between a replication source with Cloudera Manager running version 5.10 or higher and a replication target running Cloudera Manager 5.10 or higher. Because this change replicates more information, the same schedule may take more time to complete if column statistics are present.

 

Thanks and hope this helps.

Li

Translate
Li Wang, Technical Solution Manager
DNADatangineer
DNADatangineer
Silver ⭐️
November 4, 2022

Hi!

 

Do you know the steps how to disable the replication of table table column statistics since it's effect the performance while we run the BDR?

Translate
DianaTorres
Community Manager
DianaTorres
Community Manager
November 4, 2022

@DNADatangineer As this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post.

Translate
Regards, Diana Torres, Senior Community Moderator
Terms & ConditionsAccessibility statement