[ https://issues.apache.org/jira/browse/HIVE-5301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13771664#comment-13771664 ]
Prasad Mujumdar commented on HIVE-5301: --------------------------------------- [~ashutoshc] Agreed. I have tested extensively with Derby and MySQL with 0.10. Did test the upgrade of empty schema (generated using this tool) as well. But the 0.7 to 0.8 upgrade is more complex due to data move which is not tested by that. I will setup 0.7 with test data and verify the upgrade options. will attach the output of the tests. > Add a schema tool for offline metastore schema upgrade > ------------------------------------------------------ > > Key: HIVE-5301 > URL: https://issues.apache.org/jira/browse/HIVE-5301 > Project: Hive > Issue Type: Bug > Components: Metastore > Affects Versions: 0.11.0 > Reporter: Prasad Mujumdar > Assignee: Prasad Mujumdar > Fix For: 0.12.0 > > Attachments: HIVE-5301.1.patch, HIVE-5301-with-HIVE-3764.0.patch > > > HIVE-3764 is addressing metastore version consistency. > Besides it would be helpful to add a tool that can leverage this version > information to figure out the required set of upgrade scripts, and execute > those against the configured metastore. Now that Hive includes Beeline > client, it can be used to execute the scripts. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira