Support Questions

Find answers, ask questions, and share your expertise

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

avatar
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

avatar
Explorer

I've reinstalled Hive and it's solved!

Thanks

 

View solution in original post

2 REPLIES 2

avatar
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.

avatar
Explorer

I've reinstalled Hive and it's solved!

Thanks