Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Hive password using embedded db, postgresql

avatar
Contributor

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.

 

 

 

1 ACCEPTED SOLUTION

avatar
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

View solution in original post

6 REPLIES 6

avatar
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

avatar
Expert Contributor

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?

 

 

avatar
Expert Contributor
Did you find anything, to view hive or other passwords

avatar
Explorer

That is only helpful if the value is not encrypted

avatar
Expert Contributor
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

avatar
New Contributor

This worked like a charm! Thanks a lot.