[
https://issues.apache.org/jira/browse/HIVE-15566?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16401331#comment-16401331
]
Bharathkrishna Guruvayoor Murali commented on HIVE-15566:
---------------------------------------------------------
This issue is not reproducible now. Tested in Hive branches for 2.1.1 as well
as 2.3.0.
I tried :
{code:java}
./schematool -dbType derby -initSchemaTo 1.2.0
./schematool -dbType derby -upgradeSchema{code}
The upgrade happened successfully.
> Schema tool upgrade schema fails from 1.2.1 to 2.1.1 because COMPACTION_QUEUE
> does not exist
> --------------------------------------------------------------------------------------------
>
> Key: HIVE-15566
> URL: https://issues.apache.org/jira/browse/HIVE-15566
> Project: Hive
> Issue Type: Bug
> Components: Hive
> Reporter: Vihang Karajgaonkar
> Assignee: Bharathkrishna Guruvayoor Murali
> Priority: Major
>
> When we use schematool to upgrade metastore schema from 1.2.1 to 2.x* it
> fails with the error
> "ALTER TABLE' cannot be performed on 'COMPACTION_QUEUE' because it does not
> exist"
> The table COMPACTION_QUEUE is created hive-txn-schema-2.1.0.derby.sql but the
> upgrade script does not seem to call it.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
