hive3.1.2 安装及其配置

1.hive安装包下载及安装

在安装hive之前,请确保服务器已安装hadoop以及mysql!
传送门:单机版hadoop安装
下载地址：Hive安装包
选择apache-hive-3.1.2-bin.tar.gz下载。
把apache-hive-3.1.2-bin.tar.gz解压到指定路径

tar zxvf apache-hive-3.1.2-bin.tar.gz -C /usr/local/hive-3.1.2/

---

2.环境变量配置

vi /etc/profile

加入下面配置

export HIVE_HOME=/usr/local/hive-3.1.2/ 
export PATH=$PATH:$HIVE_HOME/bin；

让配置生效

source /etc/profile

---

3.配置hive文件

cd  /usr/local/hive-3.1.2/conf

把初始化的配置文件 复制一份出来 并且改名

cp hive-env.sh.template hive-env.sh
cp hive-default.xml.template hive-site.xml
cp hive-log4j2.properties.template hive-log4j2.properties
cp hive-exec-log4j2.properties.template hive-exec-log4j2.properties

---

4.配置hive-env.sh

vi hive-env.sh

加入下面配置

# Set HADOOP_HOME to point to a specific hadoop install directory
export HADOOP_HOME=/usr/local/hadoop-3.2.2/ #hadoop安装路径

# Hive Configuration Directory can be controlled by:
export HIVE_CONF_DIR=/usr/local/hive-3.1.2/conf/ #hive路径

# Folder containing extra ibraries required for hive compilation/execution can be controlled by:
 export HIVE_AUX_JARS_PATH=/usr/local/hive-3.1.2/lib/      #hivejar包路径

---

5.配置hive-site.xml文件

首先使用hadoop创建3个文件夹

hadoop fs -mkdir -p /user/hive/warehouse
hadoop fs -mkdir -p /user/hive/tmp
hadoop fs -mkdir -p /user/hive/log

修改文件夹权限

hadoop fs -chmod -R 777 /user/hive/warehouse
hadoop fs -chmod -R 777 /user/hive/tmp
hadoop fs -chmod -R 777 /user/hive/log

vi hive-site.xml

在标签加入下面配置:

<configuration>
 <property>
   <name>system:java.io.tmpdir</name>
   <value>/home/hadoop/apps/hive/tmp</value>
 </property>
 <property>
    <name>system:user.name</name>
    <value>hive</value>
 </property>

 <property>
    <name>hive.exec.scratchdir</name>
    <value>/user/hive/tmp</value>
 </property>
 <property>
    <name>hive.metastore.warehouse.dir</name>
    <value>/user/hive/warehouse</value>
 </property>
 <property>
    <name>hive.querylog.location</name>
    <value>/user/hive/log</value>
 </property>
 <property>
    <name>javax.jdo.option.ConnectionURL</name>
    <value>jdbc:mysql://172.18.111.104:3306/hive?createDatabaseIfNotExist=true</value>
    <description>JDBC connect string for a JDBC metastore</description>
 </property>
 <property>
    <name>javax.jdo.option.ConnectionDriverName</name>
    <value>com.mysql.cj.jdbc.Driver</value>
    <description>Driver class name for a JDBC metastore</description>
 </property>

 <property>
    <name>javax.jdo.option.ConnectionUserName</name>
    <value>root</value>
    <description>username to use against metastore database</description>
 </property>

 <property>
    <name>javax.jdo.option.ConnectionPassword</name>
    <value>password</value>
    <description>password to use against metastore database</description>
 </property>
<property>
    <name>datanucleus.schema.autoCreateAll</name>
    <value>true</value> </property>
<property>
    <name>hive.metastore.schema.verification</name>
    <value>false</value>
 </property>

---

6.初始化数据库

schematool -dbType mysql -initSchema

---

7.启动Hive

cd /usr/local/hive-3.1.2/bin
./hive

进行简单的验证:

show databases;

至此,Hive就安装成功了.