[ https://issues.apache.org/jira/browse/HIVE-23318?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17096309#comment-17096309 ]
Denys Kuzmenko edited comment on HIVE-23318 at 4/30/20, 8:39 AM: ----------------------------------------------------------------- I think it would be a cleaner solution if we could introduce new TxnType for materialized views and set it in OpenTxnRequest when opening new transaction. At the commit step we are already loading & locking transaction record, that has TxnType attribute. was (Author: dkuzmenko): I think it would be a cleaner solution if we could introduce new TxnType for materialized views and set it in OpenTxnRequest when opening new transaction. > 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, Materialized views > Reporter: Rajesh Balamohan > Priority: Minor > > 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)