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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to