Hive安装启动填坑

Hive下载

hive下载地址：http://mirror.bit.edu.cn/apache/hive/
解压到/usr/local：tar -zxvf apache-hive-2.1.1-bin.tar.gz -C /usr/local/
重命名：mv apache-hive-2.3.4-bin/ hive-2.3.4
修改环境变量并保存

/etc/profile：vim /etc/profile

export HIVE_HOME=/usr/local/hive
export PATH=$PATH:$HIVE_HOME/bin

修改完后执行 source /etc/profile

执行 hive --version

第一个坑

Caused by: java.net.NoRouteToHostException: No Route to Host from  docker-hadoop/127.0.0.1 to docker-hadoop:9000 failed on socket timeout exception: java.net.NoRouteToHostException: No route to host;

解决方案：
关闭防火墙，
centos：

查看状态  firewall-cmd --state
关闭防火墙：systemctl stop firewalld.service

至此安装成功，接着配置hive-site.xml：

$ cd /usr/local/hive/conf
$ cp hive-default.xml.template hive-site.xml

在hive-site.xml文件开始的地方，添加mysql配置（后面有坑）：

<?xml version="1.0" encoding="UTF-8" standalone="no"?><?xml-stylesheet type="text/xsl" href="configuration.xsl"?><!--
Licensed to the Apache Software Foundation (ASF) under one or more
contributor license agreements. See the NOTICE file distributed with
this work for