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.
Venkat, can you confirm that you can connect to the Hive DB with a jdbc client such as DBVisualizer?
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?