Hive Metastore没有创建MYSQL或Derby Connection。
对于 Derby
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
最佳答案
我认为问题出在您的网址上。如下修改URL。把mysql端口号。
Metastore连接URL:jdbc:mysql://localhost:3306/metastore
关于mysql - Hive Metastore未创建MYSQL或Derby连接,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/21451622/