Skip to main content
mahfooz
Bronze III
August 26, 2020
Solved

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

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.

Shelton
SheltonAnswer
Gold ⭐️⭐️⭐️
August 28, 2020

@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

1 reply

Shelton
SheltonAnswer
Gold ⭐️⭐️⭐️
August 28, 2020

@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

Translate