drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Boaz Ben-Zvi (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5616) Hash Agg Spill: OOM while reading irregular varchar data
Date Wed, 28 Jun 2017 22:32:00 GMT
Boaz Ben-Zvi created DRILL-5616:

             Summary: Hash Agg Spill: OOM while reading irregular varchar data
                 Key: DRILL-5616
                 URL: https://issues.apache.org/jira/browse/DRILL-5616
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Relational Operators
    Affects Versions: 1.11.0
            Reporter: Boaz Ben-Zvi
            Assignee: Boaz Ben-Zvi
             Fix For: 1.11.0

An OOM while aggregating a table of two varchar columns where sizes vary significantly ( 
about 8 bytes long in average, but 250 bytes max )

alter session set `planner.width.max_per_node` = 1;
alter session set `planner.memory.max_query_memory_per_node` = 327127360;
select count(*) from (select max(`filename`) from dfs.`/drill/testdata/hash-agg/data2` group
by no_nulls_col, nulls_col) d;

Error: RESOURCE ERROR: One or more nodes ran out of memory while executing the query.

OOM at Second Phase. Partitions: 2. Estimated batch size: 12255232. Planned batches: 0. Rows
spilled so far: 434127447 Memory limit: 163563680 so far allocated: 150601728.
Fragment 1:0

This message was sent by Atlassian JIRA

View raw message