You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2020/04/29 15:12:40 UTC
[GitHub] [incubator-superset] aguspina opened a new issue #9683: Can't connect to mongodb BI connector with mysql driver
aguspina opened a new issue #9683:
URL: https://github.com/apache/incubator-superset/issues/9683
I'm connecting superset to mongodb BI connector through mysql driver but i'm getting the following error when I try to add the database:
```
DEBUG:superset.models.core:Database.get_sqla_engine(). Masked URL: mysql:/XXXXXX:XXXXXXXXXX@XX:XXXX/XXXXX
ERROR:superset.views.core:Unexpected error (MySQLdb._exceptions.ProgrammingError) (1064, "parse sql 'ROLLBACK' error: unexpected ID at position 9 near ROLLBACK")
```
I'm using superset with docker-compose installation.
----------------------------------------------------------------
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.
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] [incubator-superset] dpgaspar commented on issue #9683: Can't connect to mongodb BI connector with mysql driver
Posted by GitBox <gi...@apache.org>.
dpgaspar commented on issue #9683:
URL: https://github.com/apache/incubator-superset/issues/9683#issuecomment-621279041
Hi @aguspina mongodb is not supported by superset.
Yet, mongodb BI connector should translate SQL to mongoDB (but it may not be that simple), are you using this has the metadata DB?
----------------------------------------------------------------
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.
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] [incubator-superset] aguspina commented on issue #9683: Can't connect to mongodb BI connector with mysql driver
Posted by GitBox <gi...@apache.org>.
aguspina commented on issue #9683:
URL: https://github.com/apache/incubator-superset/issues/9683#issuecomment-621289691
Great. I'm trying to add Mongo through the ui for analytics. I'm using this driver https://pypi.org/project/mysqlclient/ and the sqlalchemy look like this mysql:/XXXXXX:XXXXXXXXXX@XX:XXXX/XXXXX.
----------------------------------------------------------------
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.
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] [incubator-superset] aguspina commented on issue #9683: Can't connect to mongodb BI connector with mysql driver
Posted by GitBox <gi...@apache.org>.
aguspina commented on issue #9683:
URL: https://github.com/apache/incubator-superset/issues/9683#issuecomment-621281517
Hey @dpgaspar ! Thanks for the answer. I didn't understand completely the final question... I'm not sure what you mean when you say "metadata DB".
----------------------------------------------------------------
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.
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] [incubator-superset] stale[bot] closed issue #9683: Can't connect to mongodb BI connector with mysql driver
Posted by GitBox <gi...@apache.org>.
stale[bot] closed issue #9683:
URL: https://github.com/apache/incubator-superset/issues/9683
----------------------------------------------------------------
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.
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] [incubator-superset] dpgaspar commented on issue #9683: Can't connect to mongodb BI connector with mysql driver
Posted by GitBox <gi...@apache.org>.
dpgaspar commented on issue #9683:
URL: https://github.com/apache/incubator-superset/issues/9683#issuecomment-621287258
Well, superset has a metadata DB that contains data about your users, dashboards, charts etc... this DB is defined on the config by `SQLALCHEMY_DATABASE_URI`
All the other DB's for analytics are defined on the UI and may need specific dbapi drivers
----------------------------------------------------------------
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.
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] [incubator-superset] stale[bot] commented on issue #9683: Can't connect to mongodb BI connector with mysql driver
Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #9683:
URL: https://github.com/apache/incubator-superset/issues/9683#issuecomment-650781821
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue `.pinned` to prevent stale bot from closing the issue.
----------------------------------------------------------------
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.
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