[Feature] add Trino JDBC and\or Arrow Flight SQL JDBC or ADBC 🚀

[YuriyGavrilov]

Search before asking

• [X] I had searched in the feature and found no similar feature requirement.

Description

First thing is to add existing Trino JDBC Drives Support as source and sink connector.

• [ ] Add Trino JDBC as source connector
• [ ] Add Trino JDBC as sink connector
• [ ] Think about Trino as engine (maybe)
• [ ] Add Arrow Flight SQL as source connector ( as JDBC or ADBC )
• [ ] Add Arrow Flight SQL as sink connector ( as JDBC or ADBC )

Just to leave this here:

• https://www.vldb.org/pvldb/vol10/p1022-muehleisen.pdf

Some good example of Flight SQL server as reference:

• https://github.com/voltrondata/flight-sql-server-example
• https://www.kamu.dev/blog/2023-09-datafusion-flightsql/ https://github.com/kamu-data/kamu-cli
• https://www.postgresql.org/about/news/apache-arrow-flight-sql-adapter-for-postgresql-010-2716/

Usage Scenario

• Data synchronization from Trino
• Data synchronization to Trino
• Using Trino as SQL engine for transformer ( including data enrichment from source to sink by existing data in Trino )
• Fast data synchronization by Arrow Flight support

Related issues

About Trino Dialect - https://github.com/apache/seatunnel/issues/4162

Are you willing to submit a PR?

• [ ] Yes I am willing to submit a PR!

Code of Conduct

• [X] I agree to follow this project's Code of Conduct

[sanjaychitransh]

hi ,I have completed trino connector development, tested working I will submit PR

[YuriyGavrilov]

@sanjaychitransh great job thx!