Re: [I] `SortMergeJoinExec` fails to allocate memory but should spill instead [datafusion-comet]

["andygrove (via GitHub)" <gi...@apache.org>]

andygrove commented on issue #2452:
URL: https://github.com/apache/datafusion-comet/issues/2452#issuecomment-3331102917

   Adding notes for my own reference later. Spark run completes in 3486 seconds:
   
   ```
   --conf spark.driver.memory=8G \
   --conf spark.executor.instances=6 \
   --conf spark.executor.cores=8 \
   --conf spark.executor.memory=16G \
   ```
   
   The following Comet run started failing with OOM on q9 after 16 mins.
   
   ```
       --conf spark.driver.memory=8G \
       --conf spark.executor.instances=4 \
       --conf spark.executor.cores=8 \
       --conf spark.executor.memory=8G \
       --conf spark.memory.offHeap.enabled=true \
       --conf spark.memory.offHeap.size=32g \
   ```
   


-- 
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