[
https://issues.apache.org/jira/browse/DRILL-6563?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16528388#comment-16528388
]
Boaz Ben-Zvi commented on DRILL-6563:
-------------------------------------
There is nothing obvious in the recent code changes. Some unusual things in the
slow profile:
{code}
00-xx-18 PARQUET_ROW_GROUP_SCAN – wait time of 1m49s
02-xx-00 BROADCAST_SENDER – wait time of 6m1s
06-xx-08 PARQUET_ROW_GROUP_SCAN - wait time of 1m5s
07-xx-08 PARQUET_ROW_GROUP_SCAN - wait time of 2m25s
{code}
Could there have been some issue with the storage that slowed the scanners ?
[~khfaraaz] - can you attach the fast profile as well ? (to compare row counts
and times)
> TPCDS query 10 has regressed
> -----------------------------
>
> Key: DRILL-6563
> URL: https://issues.apache.org/jira/browse/DRILL-6563
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Affects Versions: 1.14.0
> Reporter: Khurram Faraaz
> Assignee: Pritesh Maker
> Priority: Major
> Fix For: 1.14.0
>
> Attachments: 24ca3c6c-90e1-a4bf-6c6f-3f981fa2d043.sys.drill,
> query10.fast_plan_old_commit, tpcds_query_10_plan_slow_140d09e.pdf,
> tpcds_query_plan_10_140d09e.txt
>
>
> 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.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
