Support Questions

Find answers, ask questions, and share your expertise
Celebrating as our community reaches 100,000 members! Thank you!

It is not in list of params that are allowed to be modified at runtime? HDP 2.5 sandbox.



i am facing a this problem while using beeline. Whenever i try to set any rule or anything i get this error.

It is not in list of params that are allowed to be modified at runtime (state=42000,code=1) i am using quickstart HDP 2.5 and i have removed every other service apart from HDFS, Spark2, Hive, TEZ, Yarn, MR2, Zookeeper, Pig and Slider.

i am making connection with this "!connect jdbc:hive2:// org.apache.hive.jdbc.HiveDriver;"

PS - i am able to set these rules using HIVE but not in Beeline


Master Mentor

@Rishabh Oberoi

Which specific property are you trying to get when you are noticing this error?

- You will not be able to set some properties at runtime unless you have included that in the whitelist until this is done and you have restarted hive service along with HiveServer2 this would not take effect.

- Have you set the following properties ?  

- Similar :

- Article: [Search for "(state=42000,code=1)" in this article]


Hi, i am setting rules for headers and other general stuff. I dont get this error while in hive.

set header='address,apartmentnumber,ciitycode,city,firstname,housenumber,,streetname,streetsuffix,zip';