Skip to main content
Monds
Bronze III
March 18, 2021
Solved

Error while processing statement: Cannot modify hive.msck.path.validation at runtime. It is not in list of params that are allowed to be modified at runtime

I'm getting this error

 

  • Error while processing statement: Cannot modify hive.msck.path.validation at runtime. It is not in list of params that are allowed to be modified at runtime

 

how can I fixed it or configure it on hive config in CM?

asish
asishAnswer
Gold ⭐️⭐️⭐️
July 2, 2021

You have to whitelist the parameter to be configured in beeline . Please follow

 

https://docs.cloudera.com/cdp/latest/data-migration/topics/ug_hive_property_overview.html

7 replies

asish
Gold ⭐️⭐️⭐️
Gold ⭐️⭐️⭐️
March 18, 2021

please change the property in 

 

Hive Metastore Server Advanced Configuration Snippet (Safety Valve) for hive-site.xml

 

     and 

 

 Hive Service Advanced Configuration Snippet (Safety Valve) for hive-site.xml

Translate
srinivasp
Gold ⭐️
July 2, 2021

Hi  

We are also getting same issue .

what property should be changed here?

 

this is from my env.

 

srinivasp_0-1625217625403.png

Please let me know.

 

Thanks in advance..

 

 

Srini Podili

Translate
asish
Gold ⭐️⭐️⭐️
asishAnswer
Gold ⭐️⭐️⭐️
July 2, 2021

You have to whitelist the parameter to be configured in beeline . Please follow

 

https://docs.cloudera.com/cdp/latest/data-migration/topics/ug_hive_property_overview.html

Translate