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

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

Highlighted

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

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
Highlighted

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

Super 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]

Highlighted

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

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

Don't have an account?