cd $HIVE_ HOME/bin
vi hive- site.xml
The reason for the error is hive- site.xml The configuration in is incomplete or the configuration item is wrong
<configuration>
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/opt/software/hadoop/hive110/warehouse</value>
</property>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://192.168.56.130:3306/hive110?createDatabaseIfNotExist=true</value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>root</value>
</property>
</configuration>
In particular, we should pay attention to whether the IP address in the IP address configuration item is correct
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://192.168.56.130:3306/hive110?createDatabaseIfNotExist=true</value>
Read More:
- Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure (How to Fix)
- How to Fix Exception in thread “main“ com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications
- Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communicat
- solve com.mysql.jdbc . exceptions.jdbc4 .MySQLSyntaxErrorException:
- Mysql database error (communications link failure)
- Loading class `com.mysql.jdbc.Driver‘. This is deprecated. The new driver class is `com.mysql.cj.jdb
- Resolve the exception MySQL lontransientconnectionexception: communications link failure during rollback()
- java.lang.AbstractMethodError:com.mysql.jdbc.Connection.isValid(I)Z
- SQL Error: 0, SQLState: 08S01 & Communications link failure
- java.lang.ClassNotFoundException : com.mysql.jdbc . driver project cannot connect to database, exception, lack of MySQL driver
- Sqoop import error communications link failure
- “Hive metadata problem” hive.metastore.HiveMetaException : Failed to get schema version.
- Analysis of JDBC connection to MySQL
- Springboot2.0.4.release report error executing DDL via JDBC statement
- com.microsoft.sqlserver . jdbc.SQLServerException : invalid object name ‘XX’
- How to solve the problem of “08001” when JDBC connects to MySQL
- com.mysql.cj.exceptions.NumberOutrange
- Solutions to errors in the final running of JDBC programming
- Encapsulation of adding, deleting and modifying database by JDBC
- Failed to obtain JDBC Connection