devanshu0987 commented on issue #19425:
URL: https://github.com/apache/datafusion/issues/19425#issuecomment-3698634838

   ```
   devanshu@MACTHVTP9C71N datafusion % datafusion-cli -m 1G -c "SELECT 
\"UserID\", extract(minute FROM to_timestamp_seconds(\"EventTime\")) AS m, 
\"SearchPhrase\", COUNT(*) FROM 'benchmarks/data/hits_partitioned' GROUP BY 
\"UserID\", m, \"SearchPhrase\" ORDER BY COUNT(*) DESC LIMIT 10;"
   DataFusion CLI v51.0.0
   
   thread 'tokio-runtime-worker' (53945863) panicked at 
/Users/devanshu/.cargo/registry/src/index.crates.io-1949cf8c6b5b557f/datafusion-physical-plan-51.0.0/src/aggregates/group_values/multi_group_by/bytes_view.rs:466:53:
   range end index 2087423 out of range for slice of length 9147
   note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace
   Error: Join Error
   caused by
   External error: task 146 panicked with message "range end index 2087423 out 
of range for slice of length 9147"
   ```
   
   ```
   devanshu@MACTHVTP9C71N datafusion % datafusion-cli -m 4G -c "SELECT 
\"UserID\", extract(minute FROM to_timestamp_seconds(\"EventTime\")) AS m, 
\"SearchPhrase\", COUNT(*) FROM 'benchmarks/data/hits_partitioned' GROUP BY 
\"UserID\", m, \"SearchPhrase\" ORDER BY COUNT(*) DESC LIMIT 10;"
   DataFusion CLI v51.0.0
   Error: Arrow error: Io error: failed to fill whole buffer
   ```
   ```
   devanshu@MACTHVTP9C71N datafusion % datafusion-cli -m 8G -c "SELECT 
\"UserID\", extract(minute FROM to_timestamp_seconds(\"EventTime\")) AS m, 
\"SearchPhrase\", COUNT(*) FROM 'benchmarks/data/hits_partitioned' GROUP BY 
\"UserID\", m, \"SearchPhrase\" ORDER BY COUNT(*) DESC LIMIT 10;"
   DataFusion CLI v51.0.0
   Error: Arrow error: Io error: failed to fill whole buffer
   ```
   
   This is replicable on a Local Mac M2 with 16GB RAM. The error changes as we 
increase the limits.


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