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
It seems to connect OK from Superset 1.5/Python 3.7, but not Superset 2.1
The connection string is trino://trino@trino-test:8080/mongodb
When I click "test connection" or "Connect to database", I get the following error (to pretty much every type of config is (ie., with/without username, with/without catalog):
ERROR: (builtins.NoneType) None
[SQL: TrinoUserError(type=USER_ERROR, name=NOT_SUPPORTED, message="Time zone not supported: Host", query_id=20230820_213230_00037_qsydp)]
(Background on this error at: https://sqlalche.me/e/14/dbapi)
This discussion was converted from issue #18762 on August 21, 2023 21:38.
Heading
Bold
Italic
Quote
Code
Link
Numbered list
Unordered list
Task list
Attach files
Mention
Reference
Menu
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
Uh oh!
There was an error while loading. Please reload this page.
-
It seems to connect OK from Superset 1.5/Python 3.7, but not Superset 2.1
The connection string is trino://trino@trino-test:8080/mongodb
When I click "test connection" or "Connect to database", I get the following error (to pretty much every type of config is (ie., with/without username, with/without catalog):
ERROR: (builtins.NoneType) None
[SQL: TrinoUserError(type=USER_ERROR, name=NOT_SUPPORTED, message="Time zone not supported: Host", query_id=20230820_213230_00037_qsydp)]
(Background on this error at: https://sqlalche.me/e/14/dbapi)
Superset Versions:
sqlalchemy-trino: 0.5.0
trino: 0.326.0
Python 3.11
trino-test server (RPM version 424):
mongodb.properties:
connector.name=mongodb
mongodb.connection-url=mongodb://test01-cl01:27017/
config.properties:
#single node install config
coordinator=true
node-scheduler.include-coordinator=true
http-server.http.port=8080
http-server.log.path=/var/log/trino/http-request.log
discovery.uri=http://trino-test:8080
Error on trino-test side:
2023-08-20T14:42:21.774-0400 INFO dispatcher-query-9 io.trino.event.QueryMonitor TIMELINE: Query 20230820_184221_00006_k3u6m :: FAILED (NOT_SUPPORTED) :: elapsed 0ms :: planning 0ms :: waiting 0ms :: scheduling 0ms :: running 0ms :: finishing 0ms :: begin 2023-08-20T14:42:21.774-04:00 :: end 2023-08-20T14:42:21.774-04:00
2023-08-20T14:43:02.435-0400 INFO dispatcher-query-10 io.trino.event.QueryMonitor TIMELINE: Query 20230820_184302_00007_k3u6m :: FAILED (NOT_SUPPORTED) :: elapsed 0ms :: planning 0ms :: waiting 0ms :: scheduling 0ms :: running 0ms :: finishing 0ms :: begin 2023-08-20T14:43:02.435-04:00 :: end 2023-08-20T14:43:02.435-04:00
As I said, I tried this on an old Superset (I think it was running Python 3.7) and all is well.
Please let me know if you need anything more.
Thanks!
Beta Was this translation helpful? Give feedback.
All reactions