Hive 基于 MySQL安装

安装MySQL

1. 下载MySQL
   找到对应的rpm-bundle.tar安装包下载即可，比如我下载的是mysql-5.7.27-1.el7.x86_64.rpm-bundle.tar
2. 检查原系统中的mariadb，并删除它

rpm -qa|grep mariadb
rpm -e mariadb-libs-1:5.5.56-2.el7.x86_64 --nodeps

3. 解压MySQL安装包

tar -xvf mysql-5.7.27-1.el7.x86_64.rpm-bundle.tar

4. 安装

rpm -ivh mysql-community-common-5.7.27-1.el7.x86_64.rpm
rmp -ivh mysql-community-client-5.7.27-1.el7.x86_64.rpm
rmp -ivh mysql-community-server-5.7.27-1.el7.x86_64.rpm
rmp -ivh mysql-community-libs-5.7.27-1.el7.x86_64.rpm
rmp -ivh mysql-community-devel-5.7.27-1.el7.x86_64.rpm  #如果需要用到HUE的，这个也安装

5. 启动MySQL

systemctl start mysqld.service
# 或者   service mysqld start

6. 查看root密码

cat /var/log/mysqld.log | grep password

7. 登录后修改密码

alter user 'root'@'localhost' identified by 'password';

8. 配置MySQL

创建一个新的数据库：create database hive;
创建一个新的用户：create user 'hiveowner'@'%' identified by 'password';
给该用户授权
					   grant all on hive.* TO 'hiveowner'@'%'; 
					   grant all on hive.* TO 'hiveowner'@'localhost' identified by 'password';

Hive安装

1. 根据自己需要下载相应的版本
   CDH版本的
   Apache社区版
2. 解压

tar -zxvf hive-1.1.0-cdh5.15.1.tar.gz -C ~/app

3. 配置环境变量

export HIVE_HOME=/home/hadoop/app/hive-1.1.0-cdh5.15.1
export PATH=$HIVE_HOME/bin:$PATH

4. 配置文件

进到$HIVE_HOME/conf目录下


新建一个hive-site.xml，内容如下 ，根据自己的环境修改value

<?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/hive??createDatabaseIfNotExist=true</value>
	</property>				
	<property>
		<name>javax.jdo.option.ConnectionDriverName</name>
		<value>com.mysql.jdbc.Driver</value>
	</property>	
	<property>
		<name>javax.jdo.option.ConnectionUserName</name>
		<value>hiveowner</value>
	</property>	
	<property>
		<name>javax.jdo.option.ConnectionPassword</name>
		<value>passsword</value>
	</property>	
	<property>
		<name>hive.cli.print.current.db</name>
		<value>true</value>
	</property>
	<property>
		<name>hive.metastore.warehouse.dir</name>
		<value>/hive/warehouse</value>
	</property>
	<property>
		<name>hive.cli.print.header</name>
		<value>true</value>
	</property>			
</configuration>

将MySQL的驱动放到$HIVE_HOME/lib目录下
5. 初始化MetaStore

schematool -dbType mysql -initSchema

6. 启动hive

[hadoop@bigdata conf]$ hive
which: no hbase in (/home/hadoop/app/scala/bin:/home/hadoop/app/zookeeper/bin:/home/hadoop/app/hive/bin:/home/hadoop/app/hadoop/bin:/home/hadoop/app/hadoop/sbin:/usr/java/jdk1.8.0_45/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/hadoop/.local/bin:/home/hadoop/bin)

Logging initialized using configuration in jar:file:/home/hadoop/app/hive-1.1.0-cdh5.15.1/lib/hive-common-1.1.0-cdh5.15.1.jar!/hive-log4j.properties
WARNING: Hive CLI is deprecated and migration to Beeline is recommended.

hive (default)> show databases;
OK
database_name
default
Time taken: 0.199 seconds, Fetched: 1 row(s)