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

01447bbe4612c593da3aad5547257868.png

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


版权声明:本文为weixin_42165508原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。
THE END
< <上一篇
下一篇>>