[DRILL-5265] External Sort consumes more memory than allocated

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Assignee: Paul Rogers
• Reporter: Rahul Kumar Challapalli
• Created: 15/Feb/17 00:20
• Updated: 26/Feb/19 04:08
• Resolved: 26/Feb/19 04:08

Description

git.commit.id.abbrev=300e934

Based on the profile for the below query, the external sort has a peak memory usage of ~126MB when only ~100MB was allocated

alter session set `planner.memory.max_query_memory_per_node` = 104857600;
alter session set `planner.width.max_per_node` = 1;
select * from dfs.`/drill/testdata/md1362` order by c_email_address;

I attached the profile and the log files