question Re: how to set more than one parameters in to &quot;hive.security.authorization.sqlstd.confwhitelist.append&quot; via ambari ui in Archives of Support Questions (Read Only) https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-set-more-than-one-parameters-in-to-quot-hive-security/m-p/142268#M35569 <P>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 ? </P> Fri, 22 Jul 2016 12:24:12 GMT sshridhar 2016-07-22T12:24:12Z how to set more than one parameters in to "hive.security.authorization.sqlstd.confwhitelist.append" via ambari ui https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-set-more-than-one-parameters-in-to-quot-hive-security/m-p/142267#M35568 <P>I have a issue here</P><P>when I set only one parameter into "hive.security.authorization.sqlstd.confwhitelist.append" via ambari ui in hive config , my hive job works fine.</P><P>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.</P><P>My settings:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="5986-qq截图20160722113134.png" style="width: 961px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/21695iF0E92022BE51D884/image-size/medium?v=v2&amp;px=400" role="button" title="5986-qq截图20160722113134.png" alt="5986-qq截图20160722113134.png" /></span></P><P>I search this question online and i got a page(<A href="https://github.com/dstreev/hdp-mac-utils/blob/master/configs/hive/hive-site.xml" target="_blank">https://github.com/dstreev/hdp-mac-utils/blob/master/configs/hive/hive-site.xml</A>)</P><P>it says it can be used with comma to separate the parameters list, but it did not work to me.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="5987-qq截图20160722113037.png" style="width: 643px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/21696i65C87FE31A7E737B/image-size/medium?v=v2&amp;px=400" role="button" title="5987-qq截图20160722113037.png" alt="5987-qq截图20160722113037.png" /></span></P><P>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 ?</P><P>thx in advance,i hope your reply</P> Mon, 19 Aug 2019 08:11:29 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-set-more-than-one-parameters-in-to-quot-hive-security/m-p/142267#M35568 Yan 2019-08-19T08:11:29Z Re: how to set more than one parameters in to "hive.security.authorization.sqlstd.confwhitelist.append" via ambari ui https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-set-more-than-one-parameters-in-to-quot-hive-security/m-p/142268#M35569 <P>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 ? </P> Fri, 22 Jul 2016 12:24:12 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-set-more-than-one-parameters-in-to-quot-hive-security/m-p/142268#M35569 sshridhar 2016-07-22T12:24:12Z Re: how to set more than one parameters in to "hive.security.authorization.sqlstd.confwhitelist.append" via ambari ui https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-set-more-than-one-parameters-in-to-quot-hive-security/m-p/142269#M35570 <P>thanks a lot for replay so quick,did i need '\' before the comma ','?</P> Fri, 22 Jul 2016 12:57:26 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-set-more-than-one-parameters-in-to-quot-hive-security/m-p/142269#M35570 Yan 2016-07-22T12:57:26Z Re: how to set more than one parameters in to "hive.security.authorization.sqlstd.confwhitelist.append" via ambari ui https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-set-more-than-one-parameters-in-to-quot-hive-security/m-p/142270#M35571 <P>hi guys , there's a good news</P><P>Finally i solve this issue by check the hiveserver2.log</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="5988-ok.png" style="width: 1343px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/21693i4258F4145845F2F1/image-size/medium?v=v2&amp;px=400" role="button" title="5988-ok.png" alt="5988-ok.png" /></span></P><P>it's not comma "," to separate the list, it is "|"</P><P>comma will occur problem</P><P>here is my setting formats</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="5989-settings.png" style="width: 1007px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/21694i0C58B69EDC3751FB/image-size/medium?v=v2&amp;px=400" role="button" title="5989-settings.png" alt="5989-settings.png" /></span></P> Mon, 19 Aug 2019 08:11:15 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-set-more-than-one-parameters-in-to-quot-hive-security/m-p/142270#M35571 Yan 2019-08-19T08:11:15Z Re: how to set more than one parameters in to "hive.security.authorization.sqlstd.confwhitelist.append" via ambari ui https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-set-more-than-one-parameters-in-to-quot-hive-security/m-p/142271#M35572 <P>hi i found the solution, thx bro</P> Fri, 22 Jul 2016 13:19:06 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-set-more-than-one-parameters-in-to-quot-hive-security/m-p/142271#M35572 Yan 2016-07-22T13:19:06Z