Support Questions

Find answers, ask questions, and share your expertise

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

avatar
Explorer

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 SOLUTIONS

avatar
Guru

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

View solution in original post

avatar
Guru

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

View solution in original post

7 REPLIES 7

avatar
Guru

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

avatar
Contributor

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

avatar
Guru

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

avatar
Contributor

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

avatar
Guru

Hi Srini,

 

This looks good.

 

Regards, Asish

avatar
Contributor

Hi Asish.

 

I saw this info from Apache documentation.

srinivasp_1-1625227598176.png

 

 

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

 

Thanks,

Srinivas

avatar
Guru

Hi Srinivas,

 

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

 

Thanks,
Asish