search

apache / druid

Apache Druid: a high performance real-time analytics database.
https://druid.apache.org/
Apache License 2.0
13.28k stars 3.66k forks source link

Jdbc connector to trino #15978

Open balajidevanaboina opened 4 months ago

balajidevanaboina commented 4 months ago

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. Screenshot from 2024-02-19 11-52-45

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...

Screenshot from 2024-02-19 11-52-45

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 commented 3 months ago

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