大数据Hive搭建部署常见报错信息原因

部分报错信息原因

目录：

1.命令： bin/hive

2.命令：schematool-initSchema-dbType mysql -verbose

3. Linux上的MySQL无法实现与外部连接

4.命令：insert into test values(111,jkjkj);

5.命令：bin/beeline -u jdbc:hive2://master:10000 -n root

6.命令：bin/schematool -dbType derby -initSchema

7.命令：mysqld –initialize –user=mysql

8.命令：schematool -initSchema -dbType mysql -verbose

1.命令： bin/hive

错误信息：

Caused by: java.net.ConnectException: Call From hadoop102/192.168.1.102 to hadoop102:9000 failed on connection exception:

java.net.ConnectException: 拒绝连接; For more details see: http://wiki.apache.org/hadoop/ConnectionRefused

原因：未启动hadoop

解决：

启动集群：

start-dfs.sh

start-yarn.sh

-----------------------------------------------------------------------------------------------------------------------

报错信息：Caused by: java.net.NoRouteToHostException: No route to host

Logging initialized using configuration in jar:file:/usr/local/src/hive/lib/hive-common-3.1.2.jar!/hive-log4j2.properties Async: true

Exception in thread "main" java.lang.RuntimeException: java.net.NoRouteToHostException: No Route to Host from  plan2/192.168.100.134 to plan1:9000 failed on socket timeout exception: java.net.NoRouteToHostException: No route to host; For more details see:  NoRouteToHost - HADOOP2 - Apache Software Foundation

原因：hive-site.xml配置文件

出现错误，需要手动解决

解决：检查是否多打了空格 、冒号： 、…