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
版权声明:本文为weixin_42165508原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。