Hive的安装与环境配置

一、Hive的安装

1. 上传安装包到/export/server/文件夹下(listenwind102)

   tar zxvf apache-hive-3.1.2-bin.tar.gz

2. 解压文件夹(listenwind102)

   tar zxvf apache-hive-3.1.2-bin.tar.gz
   

二、环境配置

1. 替换guava文件解决Hive与Hadoop之间guava版本差异(listenwind102)

   cd /export/server/apache-hive-3.1.2-bin/
   rm -rf lib/guava-19.0.jar
   cp /export/server/hadoop-3.3.0/share/hadoop/common/lib/guava-27.0-jre.jar ./lib/
   

2. 修改配置文件(listenwind102)

   cd /export/server/apache-hive-3.1.2-bin/conf
   mv hive-env.sh.template hive-env.sh
   vim hive-env.sh
   

   # 新加入的代码
   export HADOOP_HOME=/export/server/hadoop-3.3.0
   export HIVE_CONF_DIR=/export/server/apache-hive-3.1.2-bin/conf
   export HIVE_AUX_JARS_PATH=/export/server/apache-hive-3.1.2-bin/lib
   

   vim hive-site.xml
   

   <configuration>
       <!-- 存储元数据mysql相关配置 -->
       <property>
           <name>javax.jdo.option.ConnectionURL</name>
           <value