Support Questions

Find answers, ask questions, and share your expertise
Announcements
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.

avatar

Hi,

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://sandbox.hortonworks.com:10000 sandbox.hortonworks.com org.apache.hive.jdbc.HiveDriver;"

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

2 REPLIES 2

avatar
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 ?

hive.security.authorization.sqlstd.confwhitelist  
OR
hive.security.authorization.sqlstd.confwhitelist.append

- Similar : https://community.hortonworks.com/content/supportkb/48746/changing-hive-properties-in-beeline-gives-...

- Article: https://community.hortonworks.com/articles/60309/working-with-variables-in-hive-hive-shell-and-beel.... [Search for "(state=42000,code=1)" in this article]

avatar

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';