Hive“创建Hive Metastore数据库表”命令使用Cloudera Manager安装“路径A”失败 [英] Hive "Creating Hive Metastore Database Tables" command fails on installation 'Path A' using Cloudera Manager

问题描述

我正在将Cloudera Manager安装到ec2实例上。我只向群集添加了一个其他ec2实例。
安装成功，但当管理员启动群集服务时（步骤9），我得到
以下错误：

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'

我在由cloudera创建的ec2实例上手动打开端口7432，因为它似乎没有打开，我不确定如果这是一个坏主意。 cloudera经理docs声称
postgres数据库将在安装时自动创建，所以我不认为这也是
问题。

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.

它是固定的。

这篇关于Hive“创建Hive Metastore数据库表”命令使用Cloudera Manager安装“路径A”失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！