hive的安装

一 安装Mysql
1.卸载mariadb
sudo rpm -e --nodeps mariadb-libs
2.安装Mysql
sudo rpm -ivh 01_mysql-community-common-5.7.28-1.el7.x86_64.rpm
sudo rpm -ivh 02_mysql-community-libs-5.7.28-1.el7.x86_64.rpm
sudo rpm -ivh 03_mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm
sudo rpm -ivh 04_mysql-community-client-5.7.28-1.el7.x86_64.rpm
sudo rpm -ivh 05_mysql-community-server-5.7.28-1.el7.x86_64.rpm

3.初始化mysql
	sudo mysqld --initialize --user=mysql
	
4.启动Mysql服务
	systemctl start mysqld
	
5.查看/var/log/mysqld.log 查看root账号密码

6.登录mysql并修改密码 set password=password('你的密码');

7.修改可以登录mysql服务器的主机地址：%表示任意地址都可以访问
		 update user set host='%' where user='root';
		 flush privileges;#刷新表中的内容

二 安装Hive
1.解压
2.配置环境变量
3.解决jar包冲突：
mv hive/lib/log4j-slf4j-impl-2.10.0.jar hive/lib/log4j-slf4j-impl-2.10.0.bak

三 配置Hive元数据到Mysql中

1.将mysql的驱动包放到hive的lib目录下
	cp /opt/software/mysql-connector-java-5.1.48.jar ./
2.配置文件：hive-site.xml
	<?xml version="1.0"?>
	<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
	<configuration>
		<!-- jdbc连接的URL -->
		<property>
			<name>javax.jdo.option.ConnectionURL</name>
			<value>jdbc:mysql://hadoop102:3306/metastore?useSSL=false</value>
	</property>

		<!-- jdbc连接的Driver-->
		<property>
			<name>javax.jdo.option.ConnectionDriverName</name>
			<value>com.mysql.jdbc.Driver</value>
	</property>

		<!-- jdbc连接的username-->
		<property>
			<name>javax.jdo.option.ConnectionUserName</name>
			<value>root</value>
		</property>

		<!-- jdbc连接的password -->
		<property>
			<name>javax.jdo.option.ConnectionPassword</name>
			<value>123456</value>
		</property>
		<!-- Hive默认在HDFS的工作目录 -->
		<property>
			<name>hive.metastore.warehouse.dir</name>
			<value>/user/hive/warehouse</value>
		</property>
		
		<!-- 指定hiveserver2连接的端口号 -->
		<property>
			<name>hive.server2.thrift.port</name>
			<value>10000</value>
		</property>
	   <!-- 指定hiveserver2连接的host -->
		<property>
			<name>hive.server2.thrift.bind.host</name>
			<value>hadoop102</value>
		</property>

		<!-- 指定存储元数据要连接的地址 -->
		<property>
			<name>hive.metastore.uris</name>
			<value>thrift://hadoop102:9083</value>
		</property>
		<!-- 元数据存储授权  -->
		<property>
			<name>hive.metastore.event.db.notification.api.auth</name>
			<value>false</value>
	</property>
	<!-- Hive元数据存储版本的验证 -->
		<property>
			<name>hive.metastore.schema.verification</name>
			<value>false</value>
	</property>

	<!-- hiveserver2的高可用参数，开启此参数可以提高hiveserver2的启动速度 -->
	<property>
		<name>hive.server2.active.passive.ha.enable</name>
		<value>true</value>
	</property>
	</configuration>
	
 3.在mysql中创建
	create database metastore;
 4.初始化Hive的元数据库：
	schematool -initSchema -dbType mysql -verbose

加粗样式