You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "Patrick-Boerzel-Qunis (via GitHub)" <gi...@apache.org> on 2023/06/13 14:15:27 UTC
[GitHub] [superset] Patrick-Boerzel-Qunis opened a new issue, #24389: Can't fetch schema for Dremio via Flight
Patrick-Boerzel-Qunis opened a new issue, #24389:
URL: https://github.com/apache/superset/issues/24389
We have an dremio and superset installation on kubernetes.
When we create a database connection to dremio I get an successful test connection "Connection looks good".
As "Supported Databases" we use "Other" and as connection string we have something like that: "dremio+flight://<username>:<pat>@<host>:32010/<dbname>?UseEncryption=false&DisableCertificateVerification=true" where all variables are urlencoded because those can contain special characters like '='.
But when we create that database connection, it shows the error:
But the connection is created anyway.
When I test that connection, it can't fetch the schema, and shows errors. Neither in SQLLab, nor in create datasets.
But when choosing that new connection in SQLLab without choosing a schema, the query runs successfully and can be saved as new Dataset. That can then also used on charts and everything.
Last test was with following versions, but we also tried with some older ones.
superset-image: apache/superset:ebca20b80050b90a5c361358e0d582d140ccfc85
sqlalchemy_dremio version: 3.0.3
dremio version: 24.1.0
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] Patrick-Boerzel-Qunis commented on issue #24389: Can't fetch schema for Dremio via Flight
Posted by "Patrick-Boerzel-Qunis (via GitHub)" <gi...@apache.org>.
Patrick-Boerzel-Qunis commented on issue #24389:
URL: https://github.com/apache/superset/issues/24389#issuecomment-1607311963
We discovered, that it was no problem with the connection between SuperSet and Dremio, but it was a problem with timeouts between the browser/user and SuperSet. So it was no problem with SuperSet but with the network connection. Other databases had no problem, because fetching the schemata was fast. But dremio takes a few seconds for the schemata so that's why it only occured with dremio.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] c-thiel commented on issue #24389: Can't fetch schema for Dremio via Flight
Posted by "c-thiel (via GitHub)" <gi...@apache.org>.
c-thiel commented on issue #24389:
URL: https://github.com/apache/superset/issues/24389#issuecomment-1594230546
We have the same problem with a productive Dremio cluster. The error occurs after ~3 Seconds.
That's less than the time Dremio needs to provide the schema.
Running with a much smaller Dremio distribution, we don't get these issues.
A question for the superset team (@rusackas?): Is there a Timeout somewhere we could prolong to avoid errors if fetching the schema takes a few seconds?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] Patrick-Boerzel-Qunis closed issue #24389: Can't fetch schema for Dremio via Flight
Posted by "Patrick-Boerzel-Qunis (via GitHub)" <gi...@apache.org>.
Patrick-Boerzel-Qunis closed issue #24389: Can't fetch schema for Dremio via Flight
URL: https://github.com/apache/superset/issues/24389
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org