Support Questions
Find answers, ask questions, and share your expertise

I have the following error when i setup the hive through ambari.

Highlighted

I have the following error when i setup the hive through ambari.

Metastore connection URL:	 jdbc:mysql://erblrpc02/hive?createDatabaseIfNotExist=true
Metastore Connection Driver :	 com.mysql.jdbc.Driver
Metastore connection User:	 hive
org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version.
Underlying cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException : Communications link failure
2 REPLIES 2
Highlighted

Re: I have the following error when i setup the hive through ambari.

@Deepak Nayak

The issue seems to be with the connectivity with the MySQL host. Try 'telnet erblrpc02 3306' and check if the 'mysqld' process is running on the host 'erblrpc02' or not.

Highlighted

Re: I have the following error when i setup the hive through ambari.

Thank you for the reply@Sindhu

I tried doing that and the result what i found was as connection refused.

#OUTPUT

Trying 192.168.56.1...
telnet: Unable to connect to remote host: Connection refused

So next what is should do to solve this issue.