cdh+mysql没创建表,Hive“创建Hive Metastore数据库表”命令使用Cloudera Manager安装“路径A”失败...

I am installing Cloudera Manager onto an ec2 instance. I only added a single other ec2 instance to the cluster.

The installation succeeded, but when the manager initiates the cluster services (step 9 of 21) I get the

following error:

[2013-07-12 18:44:35,906]ERROR 63227[main]

com.cloudera.enterprise.dbutil.SqlRunner.open(SqlRunner.java:111)

- Error connecting to db with user 'hive' and jdbcUrl 'jdbc:postgresql://ip-xx-xxx-

xx-x.ec2.internal:7432/hive'

I manually opened port 7432 on the ec2 instance created by cloudera, because it did not appear to be open, I'm not sure if that was a bad idea. The cloudera manager docs claim

that the postgres db will be auto created on installation so I don't think that is the

problem either.

解决方案

I had the same issue. It turned out that manager instance had different Security Group than the one that was having instances launched by the manager. So, I provided full access to those security group instanced for each other.

It was fixed.