Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jdbc connector to trino #15978

Open
balajidevanaboina opened this issue Feb 27, 2024 · 1 comment
Open

Jdbc connector to trino #15978

balajidevanaboina opened this issue Feb 27, 2024 · 1 comment

Comments

@balajidevanaboina
Copy link

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
Copy link
Contributor

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants