Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Error connecting to Hive Amazon EC2 using Cloudera Manager

Error connecting to Hive Amazon EC2 using Cloudera Manager

New Contributor



I am trying to install Cloudera Enterprise in Amazon EC2. In the "Starting the cluster step", I ran into this error


Creating Hive Metastore Database Tables


[ main] SqlRunner ERROR Error connecting to db with user 'hive' and jdbcUrl 'jdbc:postgresql://ip-10-134-205-163.ap-southeast-1.compute.internal:7432/hive'

I did not see this private DNS is my EC2 instances. How do I fix this?





Caused by: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl( at org.postgresql.core.ConnectionFactory.openConnection( at org.postgresql.jdbc2.AbstractJdbc2Connection.( at org.postgresql.jdbc3.AbstractJdbc3Connection.( at org.postgresql.jdbc3g.AbstractJdbc3gConnection.( at org.postgresql.jdbc4.AbstractJdbc4Connection.( at org.postgresql.jdbc4.Jdbc4Connection.( at org.postgresql.Driver.makeConnection( at org.postgresql.Driver.connect( at java.sql.DriverManager.getConnection( at java.sql.DriverManager.getConnection( at at com.cloudera.enterprise.dbutil.SqlRunner.runSingleQuery( at com.cloudera.cmf.service.hive.HiveMetastoreDbUtil.countTables( ... 2 more Caused by: Connection timed out at Method) at at at at at at at at at org.postgresql.core.PGStream.( at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl( ... 15 more