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

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

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

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

<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
        <property>
                  <name>javax.jdo.option.ConnectionURL</name>
                          <value>jdbc:mysql://hadoop001:3306/metastore?createDatabaseIfNotExist=true</value>
                         <description>JDBC connect string for a JDBC metastore</description>
        </property>

        <property>
                  <name>javax.jdo.option.ConnectionDriverName</name>
                         <value>com.mysql.jdbc.Driver</value>
                          <description>Driver class name for a JDBC metastore</description>
        </property>

        <property>
                  <name>javax.jdo.option.ConnectionUserName</name>
                          <value>root</value>
                           <description>username to use against metastore database</description>
        </property>

        <property>
                  <name>javax.jdo.option.ConnectionPassword</name>
                          <value>199712</value>
                          <description>password to use against metastore database</description>
        </property>
</configuration>

[bigdata@hadoop001 hive]$ bin/hive

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

[bigdata@hadoop001 hive]$ bin/hive

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