[
https://issues.apache.org/jira/browse/DRILL-6374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kunal Khatua updated DRILL-6374:
--------------------------------
Description:
Run TPCH regression test on Apache Drill 1.14.0 master commit
6fcaf4268eddcb09010b5d9c5dfb3b3be5c3f903 (DRILL-6173), most of the queries
regressed.
In particular, TPC-H Query 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],
* The parent commit file name:
[^TPCH_09_2_id_2517497b-d4da-dab6-6124-abde5804a25f.json] ).
was:
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
).
> 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
> Priority: Critical
> 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, TPC-H Query 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],
> * 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)
