Centos7下Hive安装配置

1.将安装包apache-hive-2.3.7-bin.tar.gz上传到/opt/目录下
2.解压安装包到/usr/local/目录下，解压命令：
tar -zxf apache-hive-2.3.7-bin.tar.gz -C /usr/local/
mv /usr/local/apache-hive-2.3.7-bin/usr/local/hive

3.进入到Hive的安装目录的conf目录下，重命名hive-env.sh.template为hive-env.sh
修改hive-env.sh文件，在末尾添加如下内容
export HADOOP_HOME=/usr/local/hadoop-3.1.4

4.将hive-site.xml文件上传到/usr/local/hive/conf目录下
cp /opt/hive-site.xml /usr/local/hive/conf/
5.上传mysql驱动mysql-connector-java-8.0.20到/usr/local/hive/lib目录
cp /opt/mysql-connector-java-8.0.20 /usr/local/hive/lib/
6.在终端执行以下命令
rm -rf /usr/local/hive/lib/guava-14.0.1.jar
cp /usr/local/hadoop-3.1.4/share/hadoop/common/lib/guava-27.0-jre.jar /usr/local/hive/lib/

7.设置环境变量vi /etc/profile，添加：
export HIVE_HOME=/usr/local/hive
export PATH=$HIV{E}_{H}OME/bin:$PATH

source /etc/profile使配置生效

8.初始化元数据库，进入hive安装包bin目录
schematool -dbType mysql -initSchema

9.启动Hive
hive --service metastore &

/usr/local/hive/bin/hive