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

Implement Explain CBO of Update and Delete statements

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 4.0.0-alpha-1
    • CBO
    • None

    Description

      set hive.support.concurrency=true;
set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;

create table acidtlb(a int, b int) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true');

explain cbo
update acidtlb set b=777;

      doesn't print CBO plan.

      Attachments

        1. HIVE-23094.1.patch
          7 kB
          Krisztian Kasa

        Issue Links

          is related to

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-22785 Update/delete/merge statements not optimized through CBO

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          links to

          Web Link Review Board

          Activity

            People

              kkasa Krisztian Kasa
              kkasa Krisztian Kasa
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: