question HIVE metastore failed to start (password authentication failed for user "hive") in Support Questions

HIVE metastore failed to start (password authentication failed for user "hive")

mmm286 — Fri, 16 Sep 2022 12:05:59 GMT

Hi,

I've installed cloudera manager with Hive but when I'm trying to start the role, it gives me:

PSQLException: FATAL: password authentication failed for user "hive"

How fix it?

Thanks and sorry for my English!

Re: HIVE metastore failed to start (password authentication failed for user "hive")

mbigelow — Wed, 16 Aug 2017 16:23:11 GMT

Log into the postgresql instance you installed for CM and Hive, and create the hive user and give it access to the metastore db. Then update the Hive configuration to use this account.

Re: HIVE metastore failed to start (password authentication failed for user "hive")

mmm286 — Thu, 17 Aug 2017 10:33:22 GMT

I've reinstalled Hive and it's solved!

Thanks