Rajesh Balamohan created HIVE-23318:
---------------------------------------
Summary: TxnHandler need not delete from
MATERIALIZATION_REBUILD_LOCKS on need basis
Key: HIVE-23318
URL: https://issues.apache.org/jira/browse/HIVE-23318
Project: Hive
Issue Type: Improvement
Components: Hive
Reporter: Rajesh Balamohan
Observed the following queries when materialized view or any of its feature was
not used.
TxnHandler need not clear this part of txn commit. It would help in reducing
the sql parsing time in server side as well.
{noformat}
G....delete from MATERIALIZATION_REBUILD_LOCKS where mrl_txn_id = 120398082
G....delete from MATERIALIZATION_REBUILD_LOCKS where mrl_txn_id = 120398084
G....delete from MATERIALIZATION_REBUILD_LOCKS where mrl_txn_id = 120398112
{noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
