Hi, I have hive metadata running on a Postgre database. Hive was configured and setup using ambari sometime back. It seems that there is a password needed to make a thrift connection to hive server. The ODBC connection works fine without password. However for thrift connection (from Apacahe NiFi) the authentication fails and the log file says ": Could not get JDBC Connection; nested exception is org.postgresql.util.PSQLException: FATAL: password authentication failed for user "hive" org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.postgresql.util.PSQLException: FATAL: password authentication failed for user "hive" "
I searched the hive-site xml for *'**javax.jdo.option.ConnectionPassword',* but there was no such property. How do i get the initial password that was used while creating the database? I tried a lot of stuff mentioned online but none of them worked Thanks BM
