You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@datafusion.apache.org by "demetribu (via GitHub)" <gi...@apache.org> on 2024/11/22 15:11:55 UTC

Re: [I] Add spilling support for HashJoin [datafusion]

demetribu commented on issue #12952:
URL: https://github.com/apache/datafusion/issues/12952#issuecomment-2493981246

   test query
   
   ```
   ./datafusion-cli/target/debug/datafusion-cli -m 1m
   DataFusion CLI v43.0.0
   > set datafusion.optimizer.prefer_hash_join = true;
   0 row(s) fetched. 
   Elapsed 0.003 seconds.
   
   > select * from (select unnest(range(0, 100000)) id) t inner join (select unnest(range(0, 100000)) id) t1 on t.id = t1.id;
   
   External error: Resources exhausted: Failed to allocate additional 278584 bytes for HashJoinInput[13] with 58744 bytes already allocated for this reservation - 123240 bytes remain available for the total pool
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org