You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Jose Rozanec <jo...@mercadolibre.com> on 2016/06/29 13:46:30 UTC

Upgrading Metastore schema 2.0.0->2.1.0

Hi all,

Upgrading DB schema from 2.0.0 to 2.1.0 is causing an error. Did anyone
experience similar issues?

Below we leave the command and stacktrace.

Thanks,

*./schematool -dbType mysql -upgradeSchemaFrom 2.0.0*
Starting upgrade metastore schema from version 2.0.0 to 2.1.0
Upgrade script upgrade-2.0.0-to-2.1.0.mysql.sql
Error: Duplicate key name 'CONSTRAINTS_PARENT_TABLE_ID_INDEX'
Query is : CREATE INDEX `CONSTRAINTS_PARENT_TABLE_ID_INDEX` ON
KEY_CONSTRAINTS (`PARENT_TBL_ID`) USING BTREE (state=42000,code=1061)
org.apache.hadoop.hive.metastore.HiveMetaException: Upgrade FAILED!
Metastore state would be inconsistent !!
Underlying cause: java.io.IOException : Schema script failed, errorcode 2
Use --verbose for detailed stacktrace.
*** schemaTool failed ***