Description of problem: Trino gains efficiency upon issuing multiple requests per single Query. the return results by RGW should be aligned with Trino expectations (otherwise queries are rejected or results are not accurate). upon aggregation statement (count) Trino pushes down a non aggregation statement, which retrieves an empty column. Trino issue parallel multiple s3select-requests, it seems that deviation in the result relates to the number of parallel requests. Version-Release number of selected component (if applicable): How reproducible: Steps to Reproduce: 1. 2. 3. Actual results: Expected results: Additional info:
the following PR's deal with Trino / CEPH integration, and resolve various issues related to that integration. https://github.com/ceph/ceph/pull/49411 https://github.com/ceph/ceph/pull/50471 https://github.com/ceph/ceph/pull/52651