even after using schematool -dbType derby -upgradeSchema the upgrade failing.
On Wed, Nov 4, 2015 at 1:23 AM, Sergey Shelukhin <ser...@hortonworks.com> wrote: > 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> > Reply-To: "user@hive.apache.org" <user@hive.apache.org> > Date: Tuesday, November 3, 2015 at 02:56 > To: "user@hive.apache.org" <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 >
