drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paul Rogers (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-5005) Potential issues with external sort info in query profile
Date Sat, 18 Feb 2017 01:07:44 GMT

     [ https://issues.apache.org/jira/browse/DRILL-5005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Paul Rogers resolved DRILL-5005.
--------------------------------
       Resolution: Fixed
    Fix Version/s: 1.10.0

The label in the tree is left at "Sort" because, in modern Drill, all sorts use the external
sort. The older non-spillable sort is no longer used.

Memory usages for the sort were vastly revised, which should address the memory concern in
this issue.

> Potential issues with external sort info in query profile
> ---------------------------------------------------------
>
>                 Key: DRILL-5005
>                 URL: https://issues.apache.org/jira/browse/DRILL-5005
>             Project: Apache Drill
>          Issue Type: Bug
>    Affects Versions: 1.9.0
>            Reporter: Paul Rogers
>            Assignee: Paul Rogers
>            Priority: Minor
>             Fix For: 1.10.0
>
>
> Run a query that will include an external sort.
> Look at the visualized plan. The external sort is shown in the tree as just "Sort". Suggestion:
say "External Sort".
> In the operator profiles section, memory use for EXTERNAL_SORT is listed as 26MB. Yet
the file being sorted is 388 MB. Even allowing for projects of a subset of column, 26 MB seems
awfully small to hold the data set. 



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

Mime
View raw message