Support Questions
Find answers, ask questions, and share your expertise

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

Solved Go to solution

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

New Contributor

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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

Mentor

@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

View solution in original post

1 REPLY 1
Highlighted

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

Mentor

@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

View solution in original post

Don't have an account?