New Contributor
Posts: 4
Registered: ‎10-14-2013

Error connecting to Hive Amazon EC2 using Cloudera Manager



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