Hive Metastore未创建MYSQL或Derby连接 [英] Hive Metastore is not creating MYSQL or Derby Connection

问题描述

Hive Metastore没有创建MYSQL或Derby Connection.

Hive Metastore is not creating MYSQL or Derby Connection.

对于德比

schematool -dbType derby -initSchema
Metastore connection URL:    jdbc:mysql://localhost/metastore
Metastore Connection Driver :    com.mysql.jdbc.Driver
Metastore connection User:   hive

schematool -dbType derby -info
Metastore connection URL:    jdbc:mysql://localhost/metastore
Metastore Connection Driver :    com.mysql.jdbc.Driver
Metastore connection User:   hive
org.apache.hadoop.hive.metastore.HiveMetaException: Failed to load driver
*** schemaTool failed ***

对于mysql

schematool -dbType mysql -initSchema
Metastore connection URL:    jdbc:mysql://localhost/metastore
Metastore Connection Driver :    com.mysql.jdbc.Driver
Metastore connection User:   hive
org.apache.hadoop.hive.metastore.HiveMetaException: Failed to load driver
*** schemaTool failed ***

schematool -dbType mysql -info
Metastore connection URL:    jdbc:mysql://localhost/metastore
Metastore Connection Driver :    com.mysql.jdbc.Driver
Metastore connection User:   hive
org.apache.hadoop.hive.metastore.HiveMetaException: Failed to load driver
*** schemaTool failed ***

出什么问题了.

我正在运行Hive 0.12.0

I am running Hive 0.12.0

推荐答案

我认为问题出在您的URL上.修改URL，如下所示.放置mysql端口号.

I think the problem is with your URL. Modify the URL as follows. Put the mysql port no.

Metastore连接URL:jdbc:mysql://localhost:3306/metastore

Metastore connection URL: jdbc:mysql://localhost:3306/metastore

这篇关于Hive Metastore未创建MYSQL或Derby连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！