Cannot modify mapred.child.env at runtime, persists after modifying the hive-site.xml file about rhive HOT 9 OPEN

Did you restart hive-server2 after change hive-site.xml?

Hive does not support reload configuration at runtime.

from rhive.

@jakemoon Hi, thank you for the reply. No I did not restart hive-server2. Do you know how I can do that? Apologies I am a complete newbie.

from rhive.

If you use HDP, you can manage services via ambari.

http://docs.hortonworks.com/HDPDocuments/Ambari-2.1.2.1/bk_Ambari_Users_Guide/content/ch_managing_services.html

from rhive.

@jakemoon Thank you for the link. I followed the instruction and restarted hive-server2. The original error message is gone, but I am getting a new one:

Cannot modify RHIVE_UDF_DIR at runtime. It is not in list of params that are allowed to be modified at runtime.

I tried adding RHIVE_UDF_DIR to the same property next to mapred.child.env:

This brings me back the error message about mapred.child.env again. I also tried:

As per #92 , but this did not do it, either

from rhive.

try this

hive.security.authorization.sqlstd.confwhitelist.append=mapred.child.env|query.invoker|RHIVE_UDF_DIR

and restart hive-server2

from rhive.

That did not resolve the issue :( I am getting the same mapred.child.env cannot be modified error.

from rhive.

@taeyoung-yoon Hi there, this is very similar to an issue that you helped solve, so if you could offer some insights here, it would be greatly appreciated!

from rhive.

@jingjingyangg
I think that Jake's comment is the correct and it is enough to solve your problem.

Anyway, please try again with the following steps.

• Open and edit the 'hive-site.xml' on your HDP Hive and add "hive.security.authorization.sqlstd.confwhitelist.append" configuration as below.

<property>
    <name>hive.security.authorization.sqlstd.confwhitelist.append</name>    <value>mapred\.child\.env|query\.invoker|RHIVE_UDF_DIR</value>
    <description>Java regexes, to be appended to list set in
        hive.security.authorization.sqlstd.confwhitelist. Using this list instead
        of updating the original list means that you can append to the defaults
        set by SQL standard authorization instead of replacing it entirely.
    </description>
</property>

The value should be Java Regex but not a comma separated list.
Please don't make changes to hive.security.authorization.sqlstd.confwhitelist configuration in hive-site.xml
If you set any value to the hive.security.authorization.sqlstd.confwhitelist configuration, it will overwrite the default white list properties.
You can check the default value in your Hive env. through beeline command or your Hive user interface(query editor?) on HDP.

set hive.security.authorization.sqlstd.confwhitelist

So it would be much easier to manage the white list properties with '~confwhitelist.append' rather than '~confwhitelist'.

• Restart you Hive Server(hive-server2).
• Please double check the '~confwhitelist.append' value.

0: jdbc:hive2://localhost:10000> set hive.security.authorization.sqlstd.confwhitelist.append;

The results should be as below.

hive.security.authorization.sqlstd.confwhitelist.append=mapred\.child\.env|query\.invoker|RHIVE_UDF_DIR

• And now, try again RHive command.

from rhive.

@taeyoung-yoon Thanks a lot for the detailed reply. I followed all the steps(added the property in the .xml file, saved the file and then restarted the hive server), but strangely when I ran "set hive.security.authorization.sqlstd.confwhitelist.append' in the query editor, it says the property is undefined. But finally I was able to define it on Ambari at Services -> Hive -> Configs -> Advanced -> Custom hive-site -> Add Property and manually added a property named "hive.security.authorization.sqlstd.confwhitelist.append' with a value of "mapred.child.env|query.invoker|RHIVE_UDF_DIR". This enabled a successful connection with Hive.

@jakemoon @taeyoung-yoon thank you so much to both of you for your help!

from rhive.