Error: Duplicate key name ‘PCS

mac2024-04-04  35

初始化hive数据库失败,报错如下:

Initialization script hive-schema-2.3.0.mysql.sql Error: Duplicate key name 'PCS_STATS_IDX' (state=42000,code=1061) 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 ***

解决办法:

查看mysql中是否有hive这个数据库,如果有,删除即可。
最新回复(0)