drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dechang Gu (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5468) THCH Q18 regressed ~3x due to execution plan changes
Date Wed, 03 May 2017 17:11:04 GMT
Dechang Gu created DRILL-5468:
---------------------------------

             Summary: THCH Q18 regressed ~3x due to execution plan changes
                 Key: DRILL-5468
                 URL: https://issues.apache.org/jira/browse/DRILL-5468
             Project: Apache Drill
          Issue Type: Bug
          Components: Functions - Drill
    Affects Versions: 1.11.0
         Environment: 10+1 node ucs-micro cluster RHEL6.4
            Reporter: Dechang Gu
            Assignee: Jinfeng Ni
             Fix For: 1.11.0


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) 



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message