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

Caused by: java.lang.IllegalArgumentException: Cannot modify hive.server2.proxy.user at runtime. It is not in list of params that are allowed to be modified at runtime

Caused by: java.lang.IllegalArgumentException: Cannot modify hive.server2.proxy.user at runtime. It is not in list of params that are allowed to be modified at runtime

New Contributor

Does any one faced this issue? I have enabled below parameters to connect hive from zeppelin

hive.server2.enable.doAs to true

hive.server2.thrift.sasl.qop=auth-conf

hive.url with JDBC string ;saslQop=auth-conf

2 REPLIES 2

Re: Caused by: java.lang.IllegalArgumentException: Cannot modify hive.server2.proxy.user at runtime. It is not in list of params that are allowed to be modified at runtime

Super Mentor

@adarsh pathipati

Can you please check in the Ambari UI if you have set the property "hive.security.authorization.sqlstd.confwhitelist.append" properly or not?

Ambari UI -->  Hive --> Config --> Advanced --> Custom hiveserver2-site 

And set the property as following followed by Hive service restart:

hive.security.authorization.sqlstd.confwhitelist.append=hive\.server2\.proxy\.user

.

Reference: https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hi...

Re: Caused by: java.lang.IllegalArgumentException: Cannot modify hive.server2.proxy.user at runtime. It is not in list of params that are allowed to be modified at runtime

New Contributor

@Jay Kumar SenSharma

Parameters as specified in cluster, do you want me to add as = mapreduce\.job\.acl-view-job,hive\.query\.name,hive\.server2\.proxy\.user

hive.security.authorization.sqlstd.confwhitelist=hive\.query\.name

hive.security.authorization.sqlstd.confwhitelist.append=mapreduce\.job\.acl-view-job,hive\.query\.name