[jira] [Created] (DRILL-6374) TPCH Queries regressed and OOM when run concurrency test

["Dechang Gu (JIRA)" <ji...@apache.org>]

Dechang Gu created DRILL-6374:
---------------------------------

             Summary: TPCH Queries regressed and OOM when run concurrency test
                 Key: DRILL-6374
                 URL: https://issues.apache.org/jira/browse/DRILL-6374
             Project: Apache Drill
          Issue Type: Bug
          Components: Functions - Drill
    Affects Versions: 1.14.0
         Environment: RHEL 7
            Reporter: Dechang Gu
            Assignee: Vitalii Diravka
             Fix For: 1.14.0
         Attachments: TPCH_09_2_id_2517381b-1a61-3db5-40c3-4463bd421365.json, TPCH_09_2_id_2517497b-d4da-dab6-6124-abde5804a25f.json

Run TPCH regression test on Apache Drill 1.14.0 master commit 6fcaf4268eddcb09010b5d9c5dfb3b3be5c3f903 (DRILL-6173), most of the queries regressed. in particular, Queries 9 takes about 4x time (36 sec vs 8.6 sec), comparing to that when run against the parent commit  (9173308710c3decf8ff745493ad3e85ccdaf7c37).   Further in the concurrency test for the commit, with 48 clients each running 16 TPCH queries  (so total 768 queries are executed) with planner.width.max_per_node=5,  some queries hit OOM and caused 266 queries failed, while for the parent commit all the 768 queries completed successfully.   Profiles for TPCH_09 in the regression tests are uploaded (the failing commit 
file name: TPCH_09_2_id_2517381b-1a61-3db5-40c3-4463bd421365.json, and the parent commit file name: TPCH_09_2_id_2517497b-d4da-dab6-6124-abde5804a25f.json ).




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)