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)
