Is there still interest in a Trino2Trino connector? (Ref #21791)

[kkd927]

Hi Trino community and maintainers,

I've been very interested in the Trino2Trino connector discussed in issue #21791. However, it seems there hasn't been much recent activity on that thread. I wanted to carefully ask: is there still a need or interest within the Trino community for an upstream Trino-to-Trino connector?

Since I personally needed this for cross-cluster federated queries without data duplication, I went ahead and built a working prototype for my own use. It is largely based on the ideas and requirements discussed in the original issue.

My current implementation is available here: kkd927/trino2trino

To give a brief overview of the current prototype:

• Base: It is a read-only connector built on top of JDBC, with an intentionally conservative initial scope.
• Type Mapping: Because some Trino types are not represented cleanly over JDBC, I implemented a 5-tier transport strategy (NATIVE, VARCHAR, VARBINARY, JSON, UNSUPPORTED). This preserves many Trino-specific and nested types where a safe transport rule exists, including types such as HyperLogLog, qdigest, and various array/map/row cases.
• Performance (Pushdown): To reduce JDBC overhead, it supports projection pushdown, LIMIT / ORDER BY LIMIT, selected predicate pushdown, selected aggregation pushdown (count, count distinct, min, max, sum, avg), and some same-remote join shapes.
• Query Passthrough: It also includes a system.query passthrough table function for row-returning read queries, so remote Trino SQL can be executed directly when connector-level pushdown is not expressive enough.
• Stats: It uses remote SHOW STATS FOR <table> to provide table statistics to the local planner when available.

I am currently using this in my own environment, and it has been useful for my use cases so far.

If this still seems aligned with the project direction, I would be happy to open a Draft PR with the current implementation.

Even at this early stage, I would greatly appreciate any advice, feedback, or guidance on the architectural direction. I want to make sure it aligns with the project's standards before pushing further.

Thank you for your time and for all the great work on Trino.