question Re: Hive password using embedded db, postgresql in Support Questions

Hive password using embedded db, postgresql

whyy — Fri, 16 Sep 2022 09:31:22 GMT

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.

Re: Hive password using embedded db, postgresql

Darren — Fri, 12 Jun 2015 17:47:35 GMT

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

Re: Hive password using embedded db, postgresql

MilesYao — Thu, 23 Jun 2016 15:55:27 GMT

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?

Re: Hive password using embedded db, postgresql

kchaitanya — Fri, 16 Dec 2016 11:09:03 GMT

Did you find anything, to view hive or other passwords

Re: Hive password using embedded db, postgresql

MidwestMike — Sat, 28 Jan 2017 05:46:17 GMT

That is only helpful if the value is not encrypted

Re: Hive password using embedded db, postgresql

kchaitanya — Mon, 30 Jan 2017 04:12:07 GMT

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

Re: Hive password using embedded db, postgresql

KDDC — Wed, 29 Jan 2020 09:26:36 GMT

This worked like a charm! Thanks a lot.