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

[#1]

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.

[#2 · Accepted solution]

@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