Hive-3.1.2安装
- Hive安装采用多用户模式,有服务端和客户端
节点 | Hive服务端 | Hive客户端 | mysql管理原数据 |
---|
nn1 | ★ | | |
nn2 | | | ★ |
dn1 | | ★ | |
- 下载Hive压缩包-华中科技大学镜像
- 将文件上传到nn1节点~/pkg目录下
- 执行以下命令,在nn1安装Hive
tar -zxvf ~/pkg/apache-hive-3.1.2-bin.tar.gz -C /opt/
cd /opt
ln -s ./apache-hive-3.1.2-bin/ hive
scp -r ./hive/ dn1:`pwd`
vim /etc/profile
export HIVE_HOME=/opt/hive
export PATH=$PATH:$HIVE_HOME/bin
source /etc/profile
cp /opt/hive/conf/hive-default.xml.template /opt/hive/conf/hive-site.xml
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/user/hive/warehouse</value>
</property>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://nn2:3306/hive?createDatabaseIfNotExist=true</value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.cj.jdbc.Driver</value>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>123456</value>
</property>
</configuration>
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/user/hive/warehouse</value>
</property>
<property>
<name>hive.metastore.local</name>
<value>false</value>
</property>
<property>
<name>hive.metastore.uris</name>
<value>thrift://dn1:9083</value>
</property>
</configuration>
- 下载mysql-connector-java-8.0.19.jar
- 选择“Platform Independent”,点击第一个“Download”
- 点击下面的“No thanks,just start my download”
- 解压压缩包,得到“mysql-connector-java-8.0.19.jar”
- 上传到nn1的/opt/hive/lib目录下
- 进行初始化
schematool -dbType mysql -initSchema
- 发现报错
- 问题解决:由于jar包版本不一致,将nn1节点/opt/hive/lib路径下的guava-19.0.jar替换成/opt/hadoop/share/hadoop/common/lib下的guava-27.0-jre.jar即可
- 再次初始化,成功
- 启动hive
- 对nn1、nn2和dn1节点进行快照