HIVE 3.1.2 INSTALL

最新推荐文章于 2023-02-04 13:36:48 发布

香帅_Daniel Wu

最新推荐文章于 2023-02-04 13:36:48 发布

阅读量85

点赞数

分类专栏： XSHELL 文章标签： hive

本文链接：https://blog.csdn.net/weixin_46787788/article/details/118641773

版权

XSHELL 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

本文档详细介绍了Hive 3.1.2的安装步骤，包括解压、重命名、配置metastore连接MySQL、保持Hive与Hadoop依赖一致、拷贝MySQL驱动、初始化Hive以及启动与关闭服务的过程。同时，还提到了日志级别的调整以及如何验证HiveServer2是否启动成功。

摘要由CSDN通过智能技术生成

#1、install 省略解压、重命名

tar -zxvf /opt/download/hive-3.1.2.tar.gz -C /opt/software
mv /opt/software/hive-3.1.3 /opt/software/hive312

#2、配置

cd /opt/software/hive312/conf
mv hive-default.xml.template hive-default.xml
vim 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 local mysql</description>
		  </property>
		</configuration>
		--------------------------------------------------------------------------------------

#3、保持hive和haoop的谷歌依赖guava版本一致：用高版本覆盖低版本

cd /opt/software/hive312/lib
		ls|grep guava
		----------------------
		# guava-19.0.jar
		-----------------------
		find /opt/software/hadoop313 -name 'guava*.jar'
		---------------------------------------------------------------------
		# /opt/software/hadoop313/share/hadoop/common/lib/guava-27.0-jre.jar
		# /opt/software/hadoop313/share/hadoop/hdfs/lib/guava-27.0-jre.jar
		---------------------------------------------------------------------
		cp /opt/software/hadoop313/share/hadoop/common/lib/guava-27.0-jre.jar ./

#4、mysql驱动拷贝
#5、初始化

cd /opt/software/hive312
./bin/schematool -dbType mysql -initSchema
		#修改日志级别
		mv /opt/software/hive312/conf/hive-log4j2.properties.template /opt/software/hive312/conf/hive-log4j2.properties
		vim /opt/software/hive312/conf/hive-log4j2.properties
		-----------------------------------
		property.hive.log.level = ERROR
		-----------------------------------

#6、启动关闭hive服务

#[后台启动]
		nohup hive --service metastore>/dev/null 2>&1 &
		nohup hive --service hiveserver2>/dev/null 2>&1 &
		#[关闭]
		jps -ml
		kill -9
		#beeline [hql]
		beeline -u jdbc:hive2://20.0.0.180:10000
		-------------------------------------------
		connection refused : netstat -anp|grep 10000		#能查找表示HiveServer2启动成功
		beeline -u jdbc:hive2://20.0.0.180:10000 -n root 	#若没有没有访问权限，也可以尝试修改hdfs中hive目录访问权限