Hive报错：Error: FUNCTION 'NUCLEUS_ASCII' already exists. (state=X0Y68,code=30000)

柔情只为你懂 2022-05-13 23:16 57阅读 0赞

Hive执行schematool -initSchema -dbType derby报错。  
报错的日志：

doupeihua@doupeihua-2104 ~/software/hive/bin $ schematool -initSchema -dbType derby
    
    SLF4J: Class path contains multiple SLF4J bindings.
    SLF4J: Found binding in [jar:file:/home/doupeihua/software/hive/lib/hive-jdbc-2.0.0-standalone.jar!/org/slf4j/impl/StaticLoggerBinder.class]
    SLF4J: Found binding in [jar:file:/home/doupeihua/software/hive/lib/log4j-slf4j-impl-2.4.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
    SLF4J: Found binding in [jar:file:/home/doupeihua/software/spark-1.6.2-bin-hadoop2.6/lib/spark-assembly-1.6.2-hadoop2.6.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
    SLF4J: Found binding in [jar:file:/home/doupeihua/software/hadoop-2.6.4/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
    SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
    SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
    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 2.0.0
    Initialization script hive-schema-2.0.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 !!

解决办法**（亲测有效）**：  
**1、先将metastore\_db更名为：metastore\_db.tmp**

/hive/bin $ mv metastore_db metastore_db.tmp

**2、执行schematool -initSchema -dbType derby**

hive/bin $ schematool -initSchema -dbType derby

显示过程如下则证明问题解决：

SLF4J: Class path contains multiple SLF4J bindings.
    SLF4J: Found binding in [jar:file:/home/doupeihua/software/hive/lib/hive-jdbc-2.0.0-standalone.jar!/org/slf4j/impl/StaticLoggerBinder.class]
    SLF4J: Found binding in [jar:file:/home/doupeihua/software/hive/lib/log4j-slf4j-impl-2.4.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
    SLF4J: Found binding in [jar:file:/home/doupeihua/software/spark-1.6.2-bin-hadoop2.6/lib/spark-assembly-1.6.2-hadoop2.6.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
    SLF4J: Found binding in [jar:file:/home/doupeihua/software/hadoop-2.6.4/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
    SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
    SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
    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 2.0.0
    Initialization script hive-schema-2.0.0.derby.sql
    Initialization script completed
    schemaTool completed

转自：[https://blog.csdn.net/doupeihua/article/details/52496499][https_blog.csdn.net_doupeihua_article_details_52496499]

[https_blog.csdn.net_doupeihua_article_details_52496499]: https://blog.csdn.net/doupeihua/article/details/52496499