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 <[email protected]<mailto:[email protected]>> Reply-To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Date: Tuesday, November 3, 2015 at 02:56 To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> 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
