Hive password using embedded db, postgresql

[#1]

Hi, I need to connect one of the application to Hive and the Hive database user/password is needed. Unfortunately, I can't remember the password, is 

there any way I can retrieve the password?

I checked the hive configuration under cloudera admin, password section is hidden, ****** .

Kindly advise. Thanks.

[#2 · Accepted solution]

Hi,

You can view the actual configuration files for the hive metastore by clicking on the hive metastore, then on the Processes tab, then looking at hive-site.xml. This will include all db connection information.

Thanks,
Darren

[#3]

javax.jdo.option.ConnectionPassword value is encrypted.  Is the clear text copy saved anywhere else, or do we have to manually reset it in the DB, then update it in CM config?

How about for other services like Oozie and Hue?

[#4]

Did you find anything, to view hive or other passwords

[#5]

That is only helpful if the value is not encrypted

[#6]

Using Cloudera API you can view the password

curl -u cm_username:cm_password "http://cloudera_manager:7180/api/v11/clusters/cluster_name/services/service_name/config"

https://bigdata-tips.blogspot.in/2016/12/how-to-view-cloudera-embedded-database.html

[#7]

This worked like a charm! Thanks a lot.