解决安装配置hive时出错Caused by: com.mysql.cj.core.exceptions.CJCommunicationsException: Communications link
来源:互联网 发布:淘宝卖家为什么被处罚 编辑:程序博客网 时间:2024/06/05 10:24
当我按照教程配置好后出现打开hive出现了这样的错误
Caused by: java.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://hadoop-virtual-machine:3306/hive?CreateDatabaseIfNotExist=true, username = hive. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------
Caused by: java.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://hadoop-virtual-machine:3306/hive?CreateDatabaseIfNotExist=true, username = hive. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
在网上也找到了很多帖子也尝试了他们的方法,但是都不起作用
然后我看都有个帖子说是 重点JDBC url = jdbc:mysql://hadoop-virtual-machine:3306/hive?CreateDatabaseIfNotExist=true, username = hive.这里出了问题 ,那我就查看了我的3306端口到底有没有被监听,
netstat -an|grep 3306
结果是3306前面是127.0.0.1,是127.0.0.1:3306这么写的,我尝试着把hive-site.xml里面的 jdbc:mysql://hadoop-virtual-machine:3306/hive?CreateDatabaseIfNotExist=true改成 jdbc:mysql://127.0.0.1:3306/hive?CreateDatabaseIfNotExist=true,然后我重新把hadoop进一遍,MySQL服务也重启一遍,原谅我就是这么神经,然后开启hive
然后hive成功开启
阅读全文
0 0
- 解决安装配置hive时出错Caused by: com.mysql.cj.core.exceptions.CJCommunicationsException: Communications link
- 异常解决:Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
- Caused by: com.mysql.cj.core.exceptions.InvalidConnectionAttributeException: The server time zone...
- 关于MySQL:Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link fail
- Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
- Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
- 解决com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
- 解决com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
- com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure, Caused byNo buffer space available (maxim
- mysql连接com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link
- mysql连接com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link
- com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
- com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
- com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
- com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
- com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
- com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
- com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
- 2017 Multi-University Training Contest
- CSU
- vue.js router的配置
- 老司机找bug的十年心路历程
- 包含类的c++程序
- 解决安装配置hive时出错Caused by: com.mysql.cj.core.exceptions.CJCommunicationsException: Communications link
- hadoop学习笔记--9.hive初识
- 1. ArrayList和LinkedList总结
- hdu3037 组合数 lucas定理
- Linux 中断学习之小试牛刀篇---Linux中断内核编程
- 博弈论 SG函数模板
- TCP/IP网络编程学习笔记
- 筛选出1~1000内所有回数(Pyhton)
- vs工程中链接lib库注意事项