Hive users can read the hive-site.xml and javax.jdo.option.ConnectionPassword because the password is stored in plane text.
Can I make it encrypted ?
Thank you for your prompt reply.
I alse see that the password is encrypted on Ambari.
On the hive-site.xml in the hive metastore server(/etc/hive/conf/conf.server/hive-site.xml), I can find the password for "javax.jdo.option.ConnectionPassword" that is plane text.
Support for this was added in Hive 0.14.0 with HIVE-7634 and HADOOP-10904. By setting up a CredentialProvider to handle storing/retrieval of passwords, you can remove the need to keep the Hive metastore password in cleartext in the Hive configuration.
Thank you for your kindness. I'm sorry for the delay in responding.
As you pointed out, I couldn't work "Remove the Hive Metastore password entry from the Hive configuration" with the Ambari.
When the Hive restarts with the Ambari, the hive-site.xml will be removed.