hive连接失败

报错信息:

java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://。。。/default;auth=noSasl: java.net.ConnectException: Connection timed out: connect at org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:217) at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:155) at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105) at com.fr.third.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1461) at com.fr.third.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1525) at com.fr.third.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2165) Caused by: org.apache.thrift.transport.TTransportException: java.net.ConnectException: Connection timed out: connect at org.apache.thrift.transport.TSocket.open(TSocket.java:226) at org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:193) ... 5 more Caused by: java.net.ConnectException: Connection timed out: connect at java.net.DualStackPlainSocketImpl.connect0(Native Method) at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:589) at org.apache.thrift.transport.TSocket.open(TSocket.java:221) ... 6 more

配置信息:

7NC}JPS0XP5KN8T[D1[%3IC.png

FineReport liuday 发布于 2021-10-19 11:30
1min目标场景问卷 立即参与
回答问题
悬赏:3 F币 + 添加悬赏
提示:增加悬赏、完善问题、追问等操作,可使您的问题被置顶,并向所有关注者发送通知
共2回答
最佳回答
0
zsh331Lv8专家互助
发布于2021-10-19 12:25

[平台]Hadoop Hive数据连接-https://help.fanruan.com/finereport/doc-view-2557.html

——————

参考文档,根据hive版本替换对应驱动,重启服务再连接!

————————————————————

  • liuday liuday(提问者) 我是按照文档上来的,驱动已经替换过,服务器也重启了,但连接报这个错
    2021-10-19 12:27 
  • zsh331 zsh331 回复 liuday(提问者) 文档不会有问题,检查版本匹配!
    2022-04-14 12:46 
最佳回答
0
peng_chLv6初级互助
发布于2021-10-19 13:20

上面提示连接超时,你看下端口会不会正常,另外试下 jdbc:hive2://IP:端口/default,你看hadoop是怎么版本

  • 3关注人数
  • 516浏览人数
  • 最后回答于:2021-10-19 13:20
    请选择关闭问题的原因
    确定 取消
    返回顶部