hive mysql 元数据 配置_Hive配置元数据库metastore

配置驱动 javax.jdo.option.ConnectionDriverName

javax.jdo.option.ConnectionDriverName

org.apache.derby.jdbc.EmbeddedDriver

Driver class name for a JDBC metastore

这需要一个驱动。

1、解压mysql-connector-java-5.1.27.tar.gz 命令：tar -zxvf mysql-connector-java-5.1.27.tar.gz

2、复制驱动包到hive的lib目录

命令：cp mysql-connector-java-5.1.27-bin.jar /opt/modules/hive-0.13.1/lib/

配置ConnectionURL

javax.jdo.option.ConnectionURL

jdbc:mysql://hadoop-senior.beifeng.com:3306/metastore?createDatabaseIfNotExist=true

JDBC connect string for a JDBC metastore

说明：端口号是3306

ConnectionUserName 用户名

javax.jdo.option.ConnectionUserName

root

username to use against metastore database

ConnectionPassword 密码

javax.jdo.option.ConnectionPassword

123456

password to use against metastore database