hive和mysql集成_Hive与MySQL的集成

1.进入到，/opt/cdh-5.7.6/hive-1.1.0-cdh5.7.6/conf，目录中编辑hive-site.xml文件

2.添加参数：

javax.jdo.option.ConnectionURL

jdbc:mysql://bigdata-training001.hpsk.com:3306/cdhhive?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

123456

password to use against metastore database

hive.cli.print.current.db

true

Whether to include the current database in the Hive prompt.

3.将MySQL连接驱动放入hive的lib目录，cp /opt/tools/mysql-connector-java-5.1.27-bin.jar lib/

4.完成启动，bin/hive

原文：http://www.cnblogs.com/lsj100/p/7542452.html