[DRILL-5005] Potential issues with external sort info in query profile

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.9.0
• Fix Version/s: 1.11.0
• Assignee: Paul Rogers
• Reporter: Paul Rogers
• Reviewer: Rahul Kumar Challapalli
• Created: 04/Nov/16 18:23
• Updated: 10/Apr/17 17:39
• Resolved: 18/Feb/17 01:07

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.