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 not connecting to postgresql Metastore with authentication issues

Hive not connecting to postgresql Metastore with authentication issues

Expert Contributor

While starting hive with postgresql the service is unable to start with an exception:

psql FATAL: unable to autheticate with hive user

But we do have the user known postgres with properprivileges on hive DB.

Please let me know how to get through this.

Thanks

Venkat

3 REPLIES 3

Re: Hive not connecting to postgresql Metastore with authentication issues

Expert Contributor

Venkat, can you confirm that you can connect to the Hive DB with a jdbc client such as DBVisualizer?

Highlighted

Re: Hive not connecting to postgresql Metastore with authentication issues

New Contributor

Make sure ambari.hive.db.schema.name, javax.jdo.option.ConnectionUserName, and javax.jdo.option.ConnectionPassword from hive-site are all set correctly. Test the connection independently as @bhagan suggested. Also, do you see any other information in hive-metastore.log?

Re: Hive not connecting to postgresql Metastore with authentication issues

Expert Contributor
@bhagan

we are not able to connect to Hive Cli and Beeline and @Todd Wilson we do have the properties specified, we have resolved the issue by re-configuring the Hive metastore and Hiverserver2 instances.

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