the query circuit breaker terminates queries that use more than 60% of the heap size.
Seeing that the error happens during the collect phase, it looks like the query is reading more than 1,1 GB of data (after decompression) from the table.
Besides increasing the heap size, we documented possible approaches in this article:
With CrateDB 5.2 (to be released shortly), SQL commands for using cursors will be further extended, allowing to also scroll backward.