[Bug report] The Join query in Trino connector version 0.5.1 has slower performance than version 0.5.

[diqiu50]

Version

main branch

Describe what's wrong

The Join query in Trino connector version 0.5.1 has slower performance than version 0.5.
In the play groud query:

SELECT e.employee_id, given_name, family_name, AVG(rating) AS average_rating, SUM(total_amount) AS total_sales
FROM catalog_postgres.hr.employees AS e,
  catalog_postgres.hr.employee_performance AS p,
  catalog_hive.sales.sales AS s
WHERE e.employee_id = p.employee_id AND p.employee_id = s.employee_id
GROUP BY e.employee_id,  given_name, family_name;

Error message and/or stacktrace

0.5.0
Query 20240603_071554_00029_vtp7u, FINISHED, 1 node
Splits: 20 total, 20 done (100.00%)
2.32 [337 rows, 2.95KB] [145 rows/s, 1.27KB/s]

0.5.1
Splits: 20 total, 20 done (100.00%)
20.71 [679 rows, 3.09KB] [32 rows/s, 153B/s]

How to reproduce

Run the given sql in the play ground environment

Additional context

No response