Hive中dearby数据库初始化报错问题

最新推荐文章于 2024-04-01 16:39:01 发布

StopM

最新推荐文章于 2024-04-01 16:39:01 发布

阅读量1.2k

点赞数

文章标签： hive 数据库 hadoop

本文链接：https://blog.csdn.net/m0_56660665/article/details/125930390

版权

报错如下：

Metastore connection URL:   jdbc:derby:;databaseName=metastore_db;create=true
Metastore Connection Driver :   org.apache.derby.jdbc.EmbeddedDriver
Metastore connection User:   APP
Starting metastore schema initialization to 3.1.0
Initialization script hive-schema-3.1.0.derby.sql

Error: FUNCTION 'NUCLEUS_ASCII' already exists. (state=X0Y68,code=30000)
org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED! Metastore state would be inconsistent !!
Underlying cause: java.io.IOException : Schema script failed, errorcode 2
Use --verbose for detailed stacktrace.
*** schemaTool failed ***
去hadoop中的share/common/lib/guava-27.0-jre.jar

替换hive中的lib/guava-27.0-jre.jar即可