Jdbc connector to trino

[balajidevanaboina]

Description

Hai team, Hai everyone, SELECT * FROM TABLE( EXTERN( '{"type":"sql","database":{"type":"mysql","connectorConfig":{"connectURI":"jdbc:mysql://ip-10-9-121-173:3306/wikipedia","user":"test","password":"password"}},"sqls":["SELECT * FROM wikipedia"]}', '{"type":"json"}', '[{"name":"__time","type":"long"}]' ) ) This is query i got from kyle blog to query mysql or psql table from druid using msq engine...can any one suggest same like connect to trino and run query using jdbc connection.

And i tried with adding trino jdbc driver in lib path also it is not working....in connectorConfig i kept trino but druid is checking for extension...

Any one wants to help on this. If druid will suport to connect to trino . i think it is a good feature in druid

[sergioferragut]

I think a general JDBC extension would be a great addition for this such that any JDBC driver could be used for external access.

[github-actions[bot]]

This issue has been marked as stale due to 280 days of inactivity. It will be closed in 4 weeks if no further activity occurs. If this issue is still relevant, please simply write any comment. Even if closed, you can still revive the issue at any time or discuss it on the [email protected] list. Thank you for your contributions.

[github-actions[bot]]

This issue has been closed due to lack of activity. If you think that is incorrect, or the issue requires additional review, you can revive the issue at any time.

[zSeabraz]

I'm having the same issue man but for me its postgreSQL Though i replace the .jar with new one driver it would return same error :(