Probably you started the new Hive version before upgrading the schema. This
means manual fixing.
> On 03 Nov 2015, at 11:56, Sanjeev Verma wrote:
>
> Hi
>
> I am trying to update the metastore using schematool but getting error
>
> schematool -dbType derby -upgradeSchemaFrom 0.12
>
> Upg
> use 0.12.
>
> From: Sanjeev Verma
> Reply-To: "user@hive.apache.org"
> Date: Tuesday, November 3, 2015 at 02:56
> To: "user@hive.apache.org"
> Subject: hive metastore update from 0.12 to 1.0
>
> Hi
>
> I am trying to update the metastore usin
gt;"
mailto:user@hive.apache.org>>
Date: Tuesday, November 3, 2015 at 02:56
To: "user@hive.apache.org<mailto: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 sche
Any help will be appreciated...
On Tue, Nov 3, 2015 at 4:26 PM, Sanjeev Verma
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 'TXN
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=3)
org.apache.hadoop.hive.metastore.HiveMeta
