Modifying hive.spark.client.server.connect.timeout at runtime

mahfooz — Fri, 16 Sep 2022 14:38:40 GMT

I am unable to set below parameter when running hive query on spark engine using hive jdbc.

Cannot modify hive.spark.client.server.connect.timeout at runtime. It is in the list of parameters that can't be modified at runtime or is prefixed by a restricted variable.

set hive.spark.client.server.connect.timeout=90000

set hive.spark.client.connect.timeout=900000;

Both parameter is giving error in CDH6.3.3 but it was working in CDH5.16.1.

Kindly let us know the option to avoid timeout error.

Re: Modifying hive.spark.client.server.connect.timeout at runtime

Shelton — Fri, 28 Aug 2020 19:06:00 GMT

@mahfooz

The property value can be modified only in hive-site.xml cluster configuration file. This will oblige you to restart the stale hive configuration and becomes a cluster-wide change rather than a runtime change.

HTH

question Modifying hive.spark.client.server.connect.timeout at runtime in Support Questions

Modifying hive.spark.client.server.connect.timeout at runtime

Re: Modifying hive.spark.client.server.connect.timeout at runtime