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 <ekoif...@hortonworks.com> 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 <vanj...@yahoo.co.in> Reply-To: "user@hive.apache.org" <user@hive.apache.org> Date: Saturday, January 7, 2017 at 8:12 AM To: "user@hive.apache.org" <user@hive.apache.org> 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