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

[#1]

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?

[#2 · Accepted solution]

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

[#3 · Accepted solution]

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

[#4]

Hi  

We are also getting same issue .

what property should be changed here?

this is from my env.

Please let me know.

Thanks in advance..

Srini Podili

[#5 · Accepted solution]

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

[#6]

Hi Asish,

I'm new to hadoop ,I'm sorry asking in detail.

so the value for ishive.security.authorization.sqlstd.confwhitelist

hive\.msck\.path\.validation|hive\.msck\.repair\.batch\.size

 can u please help.

Thanks

Srini Podili

[#7]

Hi Srini,

This looks good.

Regards, Asish

[#8]

Hi Asish.

I saw this info from Apache documentation.

https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-Hi...

Thanks,

Srinivas

[#9]

Hi Srinivas,

Thanks for the update. Could you please give the kudos,if the solution has worked ?

Thanks,
Asish