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 metastore failed to start (password authentication failed for user "hive")

Solved Go to solution

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

Explorer

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!

 

1 ACCEPTED SOLUTION

Accepted Solutions

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

Explorer

I've reinstalled Hive and it's solved!

Thanks

 

2 REPLIES 2
Highlighted

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

Champion
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")

Explorer

I've reinstalled Hive and it's solved!

Thanks

 

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