how to set more than one parameters in to "hive.security.authorization.sqlstd.confwhitelist.append" via ambari ui

[#1]

I have a issue here

when I set only one parameter into "hive.security.authorization.sqlstd.confwhitelist.append" via ambari ui in hive config , my hive job works fine.

But when i set another parameter into "hive.security.authorization.sqlstd.confwhitelist.append" via ambari ui , hive did not answer well, "Error: Error while processing statement: Cannot modify 'balabalabal' at runtime. It is not in list of params that are allowed to be modified at runtime" appears.

My settings:

I search this question online and i got a page(https://github.com/dstreev/hdp-mac-utils/blob/master/configs/hive/hive-site.xml)

it says it can be used with comma to separate the parameters list, but it did not work to me.

So can any body help me with how to set more than one parameters in to "hive.security.authorization.sqlstd.confwhitelist.append" via ambari ui right ?

thx in advance,i hope your reply

[#2]

May be Hive engineer can have a better shot at answering. But can you check if '\' is correct at the end of mongo.input.split.create_input_splits ?

[#3]

thanks a lot for replay so quick,did i need '\' before the comma ','?

[#4]

hi i found the solution, thx bro

[#5 · Accepted solution]

hi guys , there's a good news

Finally i solve this issue by check the hiveserver2.log

it's not comma "," to separate the list, it is "|"

comma will occur problem

here is my setting formats