Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-5005

Potential issues with external sort info in query profile

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.9.0
    • Fix Version/s: 1.11.0
    • Component/s: None
    • Labels:
      None

      Description

      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.

        Attachments

          Activity

            People

            • Assignee:
              paul-rogers Paul Rogers
              Reporter:
              paul-rogers Paul Rogers
              Reviewer:
              Rahul Challapalli
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: