HIVE 3.1.2 安装

HIVE 3.1.2 安装

1.解压 、改名

tar -zxvf apache-hive-3.1.2-bin.tar.gz -C /opt/software/hive/
mv apache-hive-3.1.2-bin/ hive312

2.配置

cd /opt/software/hive/hive312/conf
mv hive-default.xml.template hive-default.xml
vim hive-site.xml
# 在hive-site.xml中配置以下内容
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
	<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
	<configuration>
	  <property>
		<name>javax.jdo.option.ConnectionURL</name>
		<value>jdbc:mysql://localhost:3306/hive312?createDatabaseIfNotExist=true</value>
		<description>connect to mysql for hive metastore</description>
	  </property>
	  <property>
		<name>javax.jdo.option.ConnectionDriverName</name>
		<value>com.mysql.jdbc.Driver</value>
		<description>driver for mysql</description>
	  </property>
	  <property>
		<name>javax.jdo.option.ConnectionUserName</name>
		<value>root</value>
		<description>username to mysql</description>
	  </property>
	  <property>
		<name>javax.jdo.option.ConnectionPassword</name>
		<value>12345678</value>
		<description>password to mysql</description>
	  </property>
	</configuration>

3.

cd /opt/software/hadoop/hadoop313/lib
cp /opt/software/hadoop/hadoop313/share/hadoop/common/lib/guava-27.0-jre.jar ./

4.初始化

cd /opt/software/hadoop/hadoop313/bin
./schematool -dbType mysql -initSchema

5.后台起服务

nohup hive --service metastore>/dev/null 2>&1 &
nohup hive --service hiveserver2>/dev/null 2>&1 &

6.起客户端

beeline -u jdbc:hive2://192.168.64.180:10000 -n root