hive 报错Error:name PCS_STATS_IDX (state=42000,code=1061)

hive中的报错
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 ***

我是直接删除了里面的创建的表,这和hive中配置的表一样