启动hive常见错误之-----RuntimeException: java.net.NoRouteToHostException：没有到主机的路由

最新推荐文章于 2024-04-12 21:38:57 发布

原创最新推荐文章于 2024-04-12 21:38:57 发布 · 4k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#hive启动 #报错：没有到主机路由

笔记专栏收录该内容

27 篇文章

订阅专栏

本文记录了一次Hive启动过程中遇到的NoRouteToHostException错误及其解决过程。通过关闭防火墙服务，成功解决了因网络连接问题导致的Hive无法正常启动的问题。

[hadoop@h3 bin]$ hive

which: no hbase in (/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/opt/modules/jdk1.8.0_181/bin:/opt/modules/hadoop-2.7.6/sbin:/opt/modules/hadoop-2.7.6/bin:/opt/modules/hive-2.3.3/bin:/home/hadoop/.local/bin:/home/hadoop/bin)

Logging initialized using configuration in jar:file:/opt/modules/hive-2.3.3/lib/hive-common-2.3.3.jar!/hive-log4j2.properties Async: true
Exception in thread "main" java.lang.RuntimeException: java.net.NoRouteToHostException: No Route to Host from h3/192.168.113.103 to h1:9000 failed on socket timeout exception: java.net.NoRouteToHostException: 没有到主机的路由; For more details see: http://wiki.apache.org/hadoop/NoRouteToHost
   at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:606)
   at org.apache.hadoop.hive.ql.session.SessionState.beginStart(SessionState.java:549)
   at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:750)
   at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:686)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:498)
   at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
   at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
Caused by: java.net.NoRouteToHostException: No Route to Host from h3/192.168.113.103 to h1:9000 failed on socket timeout exception: java.net.NoRouteToHostException: 没有到主机的路由; For more details see: http://wiki.apache.org/hadoop/NoRouteToHost
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
   at org.apache.hadoop.net.NetUtils.wrapWithMessage(NetUtils.java:792)
   at org.apache.hadoop.net.NetUtils.wrapException(NetUtils.java:758)
   at org.apache.hadoop.ipc.Client.call(Client.java:1480)
   at org.apache.hadoop.ipc.Client.call(Client.java:1413)
   at org.apache.hadoop.ipc.ProtobufRpcEngine$Invoker.invoke(ProtobufRpcEngine.java:229)
   at com.sun.proxy.$Proxy29.getFileInfo(Unknown Source)
   at org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolTranslatorPB.getFileInfo(ClientNamenodeProtocolTranslatorPB.java:776)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:498)
   at org.apache.hadoop.io.retry.RetryInvocationHandler.invokeMethod(RetryInvocationHandler.java:191)
   at org.apache.hadoop.io.retry.RetryInvocationHandler.invoke(RetryInvocationHandler.java:102)
   at com.sun.proxy.$Proxy30.getFileInfo(Unknown Source)
   at org.apache.hadoop.hdfs.DFSClient.getFileInfo(DFSClient.java:2117)
   at org.apache.hadoop.hdfs.DistributedFileSystem$22.doCall(DistributedFileSystem.java:1305)
   at org.apache.hadoop.hdfs.DistributedFileSystem$22.doCall(DistributedFileSystem.java:1301)
   at org.apache.hadoop.fs.FileSystemLinkResolver.resolve(FileSystemLinkResolver.java:81)
   at org.apache.hadoop.hdfs.DistributedFileSystem.getFileStatus(DistributedFileSystem.java:1317)
   at org.apache.hadoop.fs.FileSystem.exists(FileSystem.java:1425)
   at org.apache.hadoop.hive.ql.session.SessionState.createRootHDFSDir(SessionState.java:704)
   at org.apache.hadoop.hive.ql.session.SessionState.createSessionDirs(SessionState.java:650)
   at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:582)
   ... 9 more
Caused by: java.net.NoRouteToHostException: 没有到主机的路由
   at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)
   at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:717)
   at org.apache.hadoop.net.SocketIOWithTimeout.connect(SocketIOWithTimeout.java:206)
   at org.apache.hadoop.net.NetUtils.connect(NetUtils.java:531)
   at org.apache.hadoop.net.NetUtils.connect(NetUtils.java:495)
   at org.apache.hadoop.ipc.Client$Connection.setupConnection(Client.java:615)
   at org.apache.hadoop.ipc.Client$Connection.setupIOstreams(Client.java:713)
   at org.apache.hadoop.ipc.Client$Connection.access$2900(Client.java:376)
   at org.apache.hadoop.ipc.Client.getConnection(Client.java:1529)
   at org.apache.hadoop.ipc.Client.call(Client.java:1452)
   ... 29 more

考虑是防火墙没有关：

执行：

systemctl stop firewalld
==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ===
Authentication is required to manage system services or units.
Authenticating as: root
Password:
==== AUTHENTICATION COMPLETE ===

再次启动：如下显示即ok了

[hadoop@h3 bin]$ hive
which: no hbase in (/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/opt/modules/jdk1.8.0_181/bin:/opt/modules/hadoop-2.7.6/sbin:/opt/modules/hadoop-2.7.6/bin:/opt/modules/hive-2.3.3/bin:/home/hadoop/.local/bin:/home/hadoop/bin)

Logging initialized using configuration in jar:file:/opt/modules/hive-2.3.3/lib/hive-common-2.3.3.jar!/hive-log4j2.properties Async: true
Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases.
hive>