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

Creating Hive Metastore Database Tables - Failed

Creating Hive Metastore Database Tables - Failed

Explorer

Hi friend, i have this error and i have no idea from where it comes and how to fix it , am new to Cloudera please can anyone help me ?

this is a screen shot :

lol.png

 

and this is the log file :

	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
	... 11 more

Exception in thread "main" java.lang.RuntimeException: org.postgresql.util.PSQLException: The connection attempt failed.
	at com.cloudera.cmf.service.hive.HiveMetastoreDbUtil.countTables(HiveMetastoreDbUtil.java:201)
	at com.cloudera.cmf.service.hive.HiveMetastoreDbUtil.printTableCount(HiveMetastoreDbUtil.java:281)
	at com.cloudera.cmf.service.hive.HiveMetastoreDbUtil.main(HiveMetastoreDbUtil.java:331)
Caused by: org.postgresql.util.PSQLException: The connection attempt failed.
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:275)
	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
	at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
	at org.postgresql.Driver.makeConnection(Driver.java:450)
	at org.postgresql.Driver.connect(Driver.java:252)
	at java.sql.DriverManager.getConnection(DriverManager.java:571)
	at java.sql.DriverManager.getConnection(DriverManager.java:215)
	at com.cloudera.enterprise.dbutil.SqlRunner.open(SqlRunner.java:109)
	at com.cloudera.enterprise.dbutil.SqlRunner.runSingleQuery(SqlRunner.java:80)
	at com.cloudera.cmf.service.hive.HiveMetastoreDbUtil.countTables(HiveMetastoreDbUtil.java:196)
	... 2 more
Caused by: java.net.UnknownHostException: cloudera.isetso.com
	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:178)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
	at java.net.Socket.connect(Socket.java:579)
	at org.postgresql.core.PGStream.<init>(PGStream.java:68)
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
	... 11 more
+ NUM_TABLES='2019-05-04 03:53:18,166 [main] ERROR com.cloudera.enterprise.dbutil.SqlRunner  - Error connecting to db with user '\''hive'\'' and jdbcUrl '\''jdbc:postgresql://cloudera.isetso.com:7432/hive'\'''
+ [[ 1 -ne 0 ]]
+ echo 'Failed to count existing tables.'
+ exit 1

 PS : am workin on Single node. and i know its a JDBC Problem but i dont know how to fix it, please can anyone provide me with detailled steps ? Thanks.

4 REPLIES 4

Re: Creating Hive Metastore Database Tables - Failed

Explorer

Hi,

 

in case you´d want to install and configure JDBC connector to Hive, here you have the official link:

 https://www.cloudera.com/downloads/connectors/hive/jdbc/2-6-2.html

 

in that web there are documentation about installation.

 

But I think in your case the first problem is the name of the server.

Cloudera Manager is trying to look for the hostname "cloudera.isetso.com" and he can´t resolve it.

 

Check your /etc/hosts and be sure the name is correct and pointing to the right IP.

That could be a possibility.

 

Regards.

 

Re: Creating Hive Metastore Database Tables - Failed

Explorer

thank u  so soooooooooooooooo much <3

that works ! but please can u tell me why all my services are in bad health ?

does that because i'm working with 7GB of RAM ? Screenshot from 2019-05-07 05-42-34.png

Highlighted

Re: Creating Hive Metastore Database Tables - Failed

Explorer

Great! :D

 

It´s possible that you have some errors, and many of that related to the others...

You can check all errors and warning in menu option "All health issues".

 

Check if the problem it´s about RAM. But I think it´s very probably that errors are concerned by "Free disk space".

 

Cloudera shows a lot of "Warning Alerts" when directories have less of 15 % of free space, and "Critical Alerts" when free space is lower than 10 %.

In your case, with only one server, it sounds a possible cause...

 

That´s alerts do not prevent services from working, but if disk it´s full services will going down.

 

Re: Creating Hive Metastore Database Tables - Failed

New Contributor

thanks

Don't have an account?
Coming from Hortonworks? Activate your account here