启动Hive时初始化元数据失败的问题与解决方法

最新推荐文章于 2024-03-06 12:02:47 发布

白马费马

最新推荐文章于 2024-03-06 12:02:47 发布

阅读量4.6k

点赞数

文章标签： sql 数据库 database hive

本文链接：https://blog.csdn.net/Marquez96/article/details/122340167

版权

在尝试使用`schematool`启动Hive并初始化MySQL元数据时遇到问题。通过运行`schematool -dbType mysql -initSchema`命令进行操作，但遇到一些障碍。此外，检查元数据状态的命令`./schematool -dbType mysql -info`显示了错误信息，需要进一步的故障排除和修复。

摘要由CSDN通过智能技术生成

 INFO [main] metastore.HiveMetaStore: 0: Opening raw store with implementation class:org.apache.hadoop.hive.metastore.ObjectStore
2022-01-06T10:01:13,592  INFO [main] metastore.ObjectStore: ObjectStore, initialize called
2022-01-06T10:01:13,597  WARN [main] metastore.MetaStoreDirectSql: Self-test query [select "DB_ID" from "DBS"] failed; direct SQL is disabled
javax.jdo.JDODataStoreException: Error executing SQL query "select "DB_ID" from "DBS"".
        at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:543) ~[datanucleus-api-jdo-4.2.4.jar:?]
        at org.datanucleus.api.jdo.JDOQuery.executeInternal(JDOQuery.java:391) ~[datanucleus-api-jdo-4.2.4.jar:?]
        at org.datanucleus.api.jdo.JDOQuery.execute(JDOQuery.java:216) ~[datanucleus-api-jdo-4.2.4.jar:?]
        at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.runTestQuery(MetaStoreDirectSql.java:276) ~[hive-exec-3.1.2.jar:3.