Support Questions

Find answers, ask questions, and share your expertise

From where does the Hive Metastore gets database password?

avatar
Master Guru

I remember there was this property(mentioned below) in hive-site.xml for metastore password.

<property>
  <name>javax.jdo.option.ConnectionPassword</name>
  <value>as_if_I'm_going_to_paste_my_password_here</value>
</property>

I cannot see it in my hive-site.xml (HDP-2.5.0.0), I think we have some credential provider configured for this but I'm unable to find that property in hive-site.xml as well.

 <!-- Configure credential store for passwords-->
  <property>
    <name>hadoop.security.credential.provider.path</name>
    <value>jceks://file/usr/lib/hive/conf/hive.jceks</value>
  </property>

Any idea where it stores the password?

1 ACCEPTED SOLUTION

avatar
Master Guru

I got it.

/etc/hive/conf/conf.server

I was searching all the time in /etc/hive/conf/hive-site.xml and was assuming that /etc/hive/conf.server does not exists.

View solution in original post

3 REPLIES 3

avatar
Master Guru

I got it.

/etc/hive/conf/conf.server

I was searching all the time in /etc/hive/conf/hive-site.xml and was assuming that /etc/hive/conf.server does not exists.

avatar
Contributor

You can also use following command to retrieve the password - sudo java -cp "/usr/hdp/current/ranger-tagsync/lib/*" org.apache.ranger.credentialapi.buildks get javax.jdo.option.connectionpassword -provider jceks://file/etc/hive/conf/conf.server/hive-site.jceks

avatar
Contributor

may i know what action have you taken to get or change the passwd of hive metastore??