当遇到Hive无法打开，提示'The last packet sent successfully to the server was 0 milliseconds ago'的错误时，可能是因为MySQL服务出现问题。解决方法包括重启MySQL服务，随后重新启动Hadoop和Yarn，执行这些操作后通常能正常打开Hive。
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)
网上有很多种情况，有可能是MySQL崩了，需要重启MySQL，解决方案如下：
[root@hadoop102 hive]# service mysql status
MySQL is not running, but lock file (/var/lock/subsys
最低0.47元/天 解锁文章
4万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
