You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@drill.apache.org by "Khurram Faraaz (JIRA)" <ji...@apache.org> on 2017/04/07 07:10:42 UTC

[jira] [Commented] (DRILL-5005) Potential issues with external sort info in query profile

    [ https://issues.apache.org/jira/browse/DRILL-5005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15960391#comment-15960391 ] 

Khurram Faraaz commented on DRILL-5005:
---------------------------------------

[~paul-rogers] can you please point me to some existing queries that use EXTERNAL_SORT. I will execute, and verify that the memory is listed correct, for such queries.

> 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.11.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)