Thanks Eugene.
As it was an upgrade from 1.2.0 to 2.1.0 , I preferred to use the intermediate
version 1.3.0 script ("hive-txn-schema-1.3.0.derby.sql")
Had to include it in the script: upgrade-1.2.0-to-2.0.0.derby.sql. Also had to
manually check all other *HIVE* sqls in it and comment out the redundant ones.
It works fine now.
RegardsSanjeev V
On Saturday, 7 January 2017 6:22 PM, Eugene Koifman
<[email protected]> wrote:
#yiv7842000652 #yiv7842000652 -- _filtered #yiv7842000652 {panose-1:2 4 5 3 5
4 6 3 2 4;} _filtered #yiv7842000652 {font-family:Calibri;panose-1:2 15 5 2 2 2
4 3 2 4;} _filtered #yiv7842000652 {font-family:HelveticaNeue;}#yiv7842000652
#yiv7842000652 p.yiv7842000652MsoNormal, #yiv7842000652
li.yiv7842000652MsoNormal, #yiv7842000652 div.yiv7842000652MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv7842000652 a:link,
#yiv7842000652 span.yiv7842000652MsoHyperlink
{color:#0563C1;text-decoration:underline;}#yiv7842000652 a:visited,
#yiv7842000652 span.yiv7842000652MsoHyperlinkFollowed
{color:#954F72;text-decoration:underline;}#yiv7842000652
span.yiv7842000652EmailStyle17
{font-family:Calibri;color:windowtext;}#yiv7842000652 span.yiv7842000652msoIns
{text-decoration:underline;color:teal;}#yiv7842000652
.yiv7842000652MsoChpDefault {font-size:10.0pt;} _filtered #yiv7842000652
{margin:1.0in 1.0in 1.0in 1.0in;}#yiv7842000652 div.yiv7842000652WordSection1
{}#yiv7842000652 This table is defined in hive-txn-schema-2.1.0.derby.sql
From: sanjeev <[email protected]>
Reply-To: "[email protected]" <[email protected]>
Date: Saturday, January 7, 2017 at 8:12 AM
To: "[email protected]" <[email protected]>
Subject: Metastore Schema Upgrade : 'ALTER TABLE' cannot be performed on
'COMPACTION_QUEUE' because it does not exist Hi I am trying to upgrade
metastore schema from 1.2.0 to 2.1.1 using the schematool by command:
schematool -dbType derby -upgradeSchemaFrom 1.2.0 Getting an error:
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
Metastore connection URL:
jdbc:derby:;databaseName=metastore_db;create=true
Metastore Connection Driver : org.apache.derby.jdbc.EmbeddedDriver
Metastore connection User: APP
Starting upgrade metastore schema from version 1.2.0 to 2.1.0
Upgrade script upgrade-1.2.0-to-2.0.0.derby.sql
Error: 'ALTER TABLE' cannot be performed on 'COMPACTION_QUEUE' because it does
not exist. (state=42Y55,code=30000)
org.apache.hadoop.hive.metastore.HiveMetaException: Upgrade FAILED! Metastore
state would be inconsistent !!
Underlying cause: java.io.IOException : Schema script failed, errorcode 2
Use --verbose for detailed stacktrace. Is it advisable to comment out the
specific 'ALTER TABLE' in the script and retry ? If not, can you help with the
way forward. Regards Sanjeev V
