[HIVE-23318] TxnHandler should delete from MATERIALIZATION_REBUILD_LOCKS on need basis - ASF JIRA

XML

Word

Printable

JSON

Details

Type: Improvement
Status: Closed
Priority: Minor
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 4.0.0-alpha-1
Component/s: Hive, Materialized views
Labels:
None

Description

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.

  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

Attachments

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending

HIVE-23318.4.patch
06/May/20 13:37
8 kB
Marton Bod
HIVE-23318.3.patch
06/May/20 07:48
8 kB
Marton Bod
HIVE-23318.2.patch
05/May/20 10:41
8 kB
Marton Bod
HIVE-23318.1.patch
04/May/20 14:17
8 kB
Marton Bod

Activity

People

Assignee:: Marton Bod

Reporter:: Rajesh Balamohan

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 29/Apr/20 08:19

Updated:: 27/Feb/24 22:24

Resolved:: 06/May/20 23:27