Hive打不开解决方案.The last packet sent successfully to the server was 0 milliseconds ago_hive the last packet sent successfully to the serv

Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

Caused by: java.net.ConnectException: 拒绝连接 (Connection refused)

1
2
3
4
5
6

网上有很多种情况，有可能是MySQL崩了，需要重启MySQL，解决方案如下：

[root@hadoop102 hive]# service mysql status
MySQL is not running, but lock file (/var/lock/subsys/mysql[失败]ts
[root@hadoop102 hive]# service mysql start
Starting MySQL.                                            [确定]
1
2
3
4

然后重新启动Hadoop与Yarn，打开Hive即可。