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

TPCDS query 10 has regressed

    XMLWordPrintableJSON

    Details

      Description

      TPC-DS query 10 has regressed in performance from taking 3.5 seconds to execute on Apache Drill 1.14.0 commit  b92f599 , to 07 min 51.851 sec to complete execution on Apache Drill 1.14.0 commit 140d09e. Query was executed over SF1 parquet views on a 4 node cluster.

      Query plan from old and newer commit is attached here, with the query profile from newer commit.

        Attachments

        1. tpcds_query_plan_10_140d09e.txt
          44 kB
          Khurram Faraaz
        2. tpcds_query_10_plan_slow_140d09e.pdf
          63 kB
          Khurram Faraaz
        3. query10.fast_plan_old_commit
          10 kB
          Khurram Faraaz
        4. 24ca3c6c-90e1-a4bf-6c6f-3f981fa2d043.sys.drill
          96 kB
          Khurram Faraaz

          Activity

            People

            • Assignee:
              priteshm Pritesh Maker
              Reporter:
              khfaraaz Khurram Faraaz
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: