You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
The text was updated successfully, but these errors were encountered:
Description
Hai team,
![Screenshot from 2024-02-19 11-52-45](https://private-user-images.githubusercontent.com/161425306/308066738-180d6c21-4355-4c72-82a6-7f1d016e6be2.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjA1NjcyODcsIm5iZiI6MTcyMDU2Njk4NywicGF0aCI6Ii8xNjE0MjUzMDYvMzA4MDY2NzM4LTE4MGQ2YzIxLTQzNTUtNGM3Mi04MmE2LTdmMWQwMTZlNmJlMi5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwNzA5JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDcwOVQyMzE2MjdaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1mMTllMDdkZDIzZTY0MDU1MzZmMTIzNmViZTdkODBlYzdjZTI1NDRkZDJkOWVkMzI3ZWVkZDVkOTdhZjc3Y2EzJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.q1ugNP6-ZKu6BqhcTQYxCAFJvUUFkq7rCgqp2UzgfLE)
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
The text was updated successfully, but these errors were encountered: