Ashutosh Bapat created HIVE-21476: ------------------------------------- Summary: Wrap metastore backing db upgrade scripts into transaction Key: HIVE-21476 URL: https://issues.apache.org/jira/browse/HIVE-21476 Project: Hive Issue Type: Improvement Reporter: Ashutosh Bapat
The metastore backing db upgrade scripts like upgrade* scripts inĀ standalone-metastore/metastore-server/src/main/sql/* directories do not use transactions. So if a command fails in those scripts metastore db is left in an inconsistent state. Instead we should wrap each of those scripts in a transaction so that all or none of the commands take effect. Some RDBMSes, I think derby, do not support DDL in transaction. So we should do this change only for the databases which support DDL in transaction. -- This message was sent by Atlassian JIRA (v7.6.3#76005)