question Re: 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 in Support Questions

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

Monds — Tue, 21 Apr 2026 09:05:56 GMT

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 — Thu, 18 Mar 2021 09:13:50 GMT

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

srinivasp — Fri, 02 Jul 2021 09:21:58 GMT

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

asish — Fri, 02 Jul 2021 09:38:08 GMT

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

srinivasp — Fri, 02 Jul 2021 11:07:23 GMT

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

asish — Fri, 02 Jul 2021 11:37:30 GMT

Hi Srini,

This looks good.

Regards, Asish

srinivasp — Fri, 02 Jul 2021 12:06:52 GMT

Hi Asish.

I saw this info from Apache documentation.

Thanks,

Srinivas

asish — Fri, 02 Jul 2021 12:18:56 GMT

Hi Srinivas,

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

Thanks,
Asish