Is your metastore schema version actually 0.12? The upgrade should be able to determine the schema version, so there should be no need to force it to use 0.12.
From: Sanjeev Verma <sanjeev.verm...@gmail.com<mailto:sanjeev.verm...@gmail.com>> Reply-To: "user@hive.apache.org<mailto:user@hive.apache.org>" <user@hive.apache.org<mailto:user@hive.apache.org>> Date: Tuesday, November 3, 2015 at 02:56 To: "user@hive.apache.org<mailto:user@hive.apache.org>" <user@hive.apache.org<mailto:user@hive.apache.org>> Subject: hive metastore update from 0.12 to 1.0 Hi I am trying to update the metastore using schematool but getting error schematool -dbType derby -upgradeSchemaFrom 0.12 Upgrade script upgrade-0.12.0-to-0.13.0.derby.sql Error: Table/View 'TXNS' already exists in Schema 'APP'. (state=X0Y32,code=30000) org.apache.hadoop.hive.metastore.HiveMetaException: Upgrade FAILED! Metastore state would be inconsistent !! could you let me know whats going wrong here Thanks