Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-23318

TxnHandler should delete from MATERIALIZATION_REBUILD_LOCKS on need basis

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.0.0
    • 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

        1. HIVE-23318.4.patch
          8 kB
          Marton Bod
        2. HIVE-23318.3.patch
          8 kB
          Marton Bod
        3. HIVE-23318.2.patch
          8 kB
          Marton Bod
        4. HIVE-23318.1.patch
          8 kB
          Marton Bod

          Activity

            People

            • Assignee:
              Marton Bod Marton Bod
              Reporter:
              rajesh.balamohan Rajesh Balamohan
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: