Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-2871

Plan for TPC-H 20 changed with DRILL-1384 (or DRILL-2761) causing performance degradation

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Not A Problem
    • 0.9.0
    • 1.0.0
    • None

    • RHEL 6.4

    Description

      TPCH 20 on SF100 (parquet) regressed from 25sec to 110sec.

      There is a change in the query plans for the query when running on the master with commitId=e99f270 (DRILL-1384); when compared with the plan generated for the preceding commitId=2a48425 (DRILL-2514).

      Attachments

        1. 20_par100_2a48425.logical.plan
          11 kB
          Kunal Khatua
        2. 20_par100_2a48425.verbose.plan
          27 kB
          Kunal Khatua
        3. 20_par100_e99f270.logical.plan
          11 kB
          Kunal Khatua
        4. 20_par100_e99f270.verbose.plan
          28 kB
          Kunal Khatua

        Activity

          People

            Unassigned Unassigned
            kkhatua Kunal Khatua
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: