Hive快速入门系列(4) | 如何将Hive元数据配置到MySql

本系列所用到的安装包博主已经上传到百度云盘中，如有需要的可以自取。下面为链接： 链接：https://pan.baidu.com/s/10ezDJTuZl-qU2sq0hDCinw 提取码：pw12

一. 驱动拷贝1．在/opt/software/mysql-libs目录下解压mysql-connector-java-5.1.27.tar.gz驱动包

[root@hadoop001 mysql-libs]# tar -zxvf mysql-connector-java-5.1.27.tar.gz

2．拷贝/opt/software/mysql-libs/mysql-connector-java-5.1.27目录下的mysql-connector-java-5.1.27-bin.jar到/opt/module/hive/lib/

[root@hadoop001 mysql-connector-java-5.1.27]# cp mysql-connector-java-5.1.27-bin.jar /opt/module/hive/lib/

二. 配置Metastore到MySql2.1 在/opt/module/hive/conf目录下创建一个hive-site.xml

在这个时候就可以转换成hadoop用户了

[bigdata@hadoop001 mysql-connector-java-5.1.27]$ cd /opt/module/hive/conf
[bigdata@hadoop001 conf]$ vim hive-site.xml

2.2 根据官方文档配置参数，拷贝数据到hive-site.xml文件中

https://cwiki.apache.org/confluence/display/Hive/AdminManual+MetastoreAdmin

        
                  javax.jdo.option.ConnectionURL
                          jdbc:mysql://hadoop001:3306/metastore?createDatabaseIfNotExist=true
                         JDBC connect string for a JDBC metastore
        

        
                  javax.jdo.option.ConnectionDriverName
                         com.mysql.jdbc.Driver
                          Driver class name for a JDBC metastore
        

        
                  javax.jdo.option.ConnectionUserName
                          root
                           username to use against metastore database
        

        
                  javax.jdo.option.ConnectionPassword
                          199712
                          password to use against metastore database
        

配置完毕后，如果启动hive异常，可以重新启动虚拟机。（重启后，别忘了启动hadoop集群）

2.3 测试启动

[bigdata@hadoop001 hive]$ bin/hive

三. 多窗口启动Hive测试3.1 先启动MySQL

[bigdata@hadoop001 mysql-libs]$ mysql -uroot -p199712
# 查看有几个数据库
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql             |
| performance_schema |
| test               |
+--------------------+

3.2 再次打开多个窗口，启动hive

[bigdata@hadoop001 hive]$ bin/hive

3.3 启动hive后，回到MySQL窗口查看数据库，显示增加了metastore数据库

	mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| metastore          |
| mysql             |
| performance_schema |
| test               |
+--------------------+