Error Messages:
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 ***
Solution:
Go to share/common/lib/guava-27.0-jre.jar in hadoop
and Replace the lib/guava-27.0-jre.jar file in hive.
Read More:
- “Hive metadata problem” hive.metastore.HiveMetaException : Failed to get schema version.
- How to solve MySQL error 1049 (42000): unknown database ‘database’
- The difference between hive and relational database
- How to Solve mybatis returns null when querying Oracle database with char type field
- Solve the database connection failure of Discuz! Database error (1045) notconnect Forum
- Oracle database file is damaged, Error:ORA-01033 :ORACLE initialization or shutdown in progress
- Method to solve the error during initialization when DST Dont Starve Together starts
- Error reporting when importing sqoop from Mysql to hive
- Solve the error of ora-12514 when Navicat connects to Oracle Database
- How to Fix Error in module RSQL of the database interface
- How to view the version of MySQL database
- hive is not allowed to impersonate anonymous
- Solve QQ startup error: Initialization failure: 0x0000000C
- FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(me
- 1716438 – Error :” Failed to load database information Details: The Database connector crdb_bwquery.
- Java connection zookeeper high availability hive error
- Unknown error (SQLite code 14): could not open database (How to Fix)
- How to Solve Hbase Error: Master is initializing
- Execution error, return code 1 from org.apache.hadoop . hive.ql.exec .DDLTask.
- Failed: execution error, return code 1 from org.apache.hadoop . hive.ql.exec .DDLTask…