Error: Duplicate key name 'PCS_STATS_IDX' (state=42000,code=1061)

最新推荐文章于 2024-05-24 11:32:00 发布

weixin_34295316

最新推荐文章于 2024-05-24 11:32:00 发布

阅读量1.6k

点赞数

文章标签：数据库大数据 python

原文链接：https://my.oschina.net/gs80140/blog/907032

版权

2019独角兽企业重金招聘Python工程师标准>>>

Metastore connection URL:        jdbc:mysql://192.168.200.128:3306/metastore?createDatabaseIfNotExist=true
Metastore Connection Driver :    com.mysql.jdbc.Driver
Metastore connection User:       hive
Starting metastore schema initialization to 1.2.0
Initialization script hive-schema-1.2.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 !!
*** schemaTool failed ***

正常的消息是这样的

Metastore connection URL:        jdbc:mysql://192.168.200.128:3306/metastore?createDatabaseIfNotExist=true
Metastore Connection Driver :    com.mysql.jdbc.Driver
Metastore connection User:       hive
Starting metastore schema initialization to 1.2.0
Initialization script hive-schema-1.2.0.mysql.sql
Initialization script completed
schemaTool completed

转载于:https://my.oschina.net/gs80140/blog/907032