alamb opened a new issue, #19425:
URL: https://github.com/apache/datafusion/issues/19425

   ### Describe the bug
   
   Even after the fix for 
   - https://github.com/apache/datafusion/issues/18474
   
   I am trying to run the clickbench benchmark with limited memory and I can't 
seem to get it to work.
   
   Specifically I would like to run q18
   ```sql
   SELECT "UserID", extract(minute FROM to_timestamp_seconds("EventTime")) AS 
m, "SearchPhrase", COUNT(*) FROM hits GROUP BY "UserID", m, "SearchPhrase" 
ORDER BY COUNT(*) DESC LIMIT 10;
   ```
   
   With only 1G of RAM
   
   ### To Reproduce
   
   
   Run this command
   ```
   cargo run --bin datafusion-cli -- -m 1G -c "SELECT \"UserID\", 
extract(minute FROM to_timestamp_seconds(\"EventTime\")) AS m, 
\"SearchPhrase\", COUNT(*) FROM 
'/Users/andrewlamb/Software/datafusion/benchmarks/data/hits_partitioned' GROUP 
BY \"UserID\", m, \"SearchPhrase\" ORDER BY COUNT(*) DESC LIMIT 10;"
   ```
   
   It fails with this error:
   Arrow error: Io error: failed to fill whole buffer
   
   ### Expected behavior
   
   I expect the command to succeeded
   
   ### Additional context
   
   _No response_


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