Hive & ldquo; Creating database tables Metastore Hive & rdquo; the comma...
source link: https://www.codesd.com/item/hive-creating-database-tables-metastore-hive-the-command-fails-during-installation-path-a-using-cloudera-manager.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Hive & ldquo; Creating database tables Metastore Hive & rdquo; the command fails during installation 'Path A' using Cloudera Manager
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've been getting this error more and more lately.
Check your Private DNS of the created AMI in EC2 Console and compare it to the JDBC URI from the error. I've found that the Private DNS is incorrect when I get this error, though I have no clue how to get around it.
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK