You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Sanjeev Verma <sa...@gmail.com> on 2015/11/03 11:56:55 UTC

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

Re: hive metastore update from 0.12 to 1.0

Posted by Sanjeev Verma <sa...@gmail.com>.
even after using
schematool -dbType derby -upgradeSchema

the upgrade failing.

On Wed, Nov 4, 2015 at 1:23 AM, Sergey Shelukhin <se...@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 <sa...@gmail.com>
> Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
> Date: Tuesday, November 3, 2015 at 02:56
> To: "user@hive.apache.org" <us...@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
>

Re: hive metastore update from 0.12 to 1.0

Posted by Sergey Shelukhin <se...@hortonworks.com>.
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 <sa...@gmail.com>>
Reply-To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>
Date: Tuesday, November 3, 2015 at 02:56
To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@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

Re: hive metastore update from 0.12 to 1.0

Posted by Sanjeev Verma <sa...@gmail.com>.
Any help will be appreciated...

On Tue, Nov 3, 2015 at 4:26 PM, Sanjeev Verma <sa...@gmail.com>
wrote:

> 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
>

Re: hive metastore update from 0.12 to 1.0

Posted by Jörn Franke <jo...@gmail.com>.
Probably you started the new Hive version before upgrading the schema. This means manual fixing. 

> On 03 Nov 2015, at 11:56, Sanjeev Verma <sa...@gmail.com> wrote:
> 
> 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