Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive password using embedded db, postgresql

Solved Go to solution
Highlighted

Hive password using embedded db, postgresql

Explorer

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

Accepted Solutions
Highlighted

Re: Hive password using embedded db, postgresql

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
Highlighted

Re: Hive password using embedded db, postgresql

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

Highlighted

Re: Hive password using embedded db, postgresql

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?

 

 

Highlighted

Re: Hive password using embedded db, postgresql

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

Re: Hive password using embedded db, postgresql

Explorer

That is only helpful if the value is not encrypted

Re: Hive password using embedded db, postgresql

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
Highlighted

Re: Hive password using embedded db, postgresql

New Contributor

This worked like a charm! Thanks a lot.

Don't have an account?
Coming from Hortonworks? Activate your account here