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

TPCH Q18 regressed ~3x due to execution plan changes

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.11.0
    • None
    • Functions - Drill
    • None

    • 10+1 node ucs-micro cluster RHEL6.4

    Description

      In a regular regression test on Drill master (commit id 841ead4) TPCH Q18 on SF100 parquet dataset took ~81 secs, while the same query on 1.10.0 took only ~27 secs. The query time on the commit adbf363 which is right before 841ead4 is ~32 secs.
      Profiles shows the plans for the query changed quite a bit (profiles will be uploaded)

      Attachments

        1. Q18_profile_gitid_841ead4
          4.20 MB
          Dechang Gu
        2. Q18_profile_gitid_adbf363
          4.17 MB
          Dechang Gu

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. DRILL-4678 Tune metadata by generating a dispatcher at runtime

          • Critical - Crashes, loss of data, severe memory leak.
          • Resolved

          Activity

            People

              jni Jinfeng Ni
              dechanggu Dechang Gu
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: