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 2019/12/19 14:16:48 UTC
[GitHub] [incubator-superset] facePlanted opened a new issue #8871:
Integrity error,
probably unique constraint (two mysql databases with same tables)
facePlanted opened a new issue #8871: Integrity error, probably unique constraint (two mysql databases with same tables)
URL: https://github.com/apache/incubator-superset/issues/8871
With MySQL, after adding the second database and trying to add tables,
I'm getting: Integrity error, probably unique constraint
I've tried also with db.table
and db:table
and also with schema.
Is having two (or multiple) databases with the tables named in the same way
supported in superset ?
----------------------------------------------------------------
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
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] mprior10 commented on issue #8871: Integrity
error, probably unique constraint (two mysql databases with same tables)
Posted by GitBox <gi...@apache.org>.
mprior10 commented on issue #8871: Integrity error, probably unique constraint (two mysql databases with same tables)
URL: https://github.com/apache/incubator-superset/issues/8871#issuecomment-612104997
A workaround is to create a View, for the subsequent tables, so they are unique.
----------------------------------------------------------------
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
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] FredericLatour commented on issue #8871:
Integrity error,
probably unique constraint (two mysql databases with same tables)
Posted by GitBox <gi...@apache.org>.
FredericLatour commented on issue #8871: Integrity error, probably unique constraint (two mysql databases with same tables)
URL: https://github.com/apache/incubator-superset/issues/8871#issuecomment-591376185
Honestly, it sounds incredible that it's not possible to have the same table name with two different databases.
The tool must have some qualities but between this and the confusing interface, I'm done with it.
----------------------------------------------------------------
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
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] ivanmartos commented on issue #8871: Integrity
error, probably unique constraint (two mysql databases with same tables)
Posted by GitBox <gi...@apache.org>.
ivanmartos commented on issue #8871: Integrity error, probably unique constraint (two mysql databases with same tables)
URL: https://github.com/apache/incubator-superset/issues/8871#issuecomment-589097384
any update pls?
----------------------------------------------------------------
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
With regards,
Apache Git Services
---------------------------------------------------------------------
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 #8871: Integrity
error, probably unique constraint (two mysql databases with same tables)
Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #8871: Integrity error, probably unique constraint (two mysql databases with same tables)
URL: https://github.com/apache/incubator-superset/issues/8871#issuecomment-587025610
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
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] lilykuang commented on issue #8871: Integrity error, probably unique constraint (two mysql databases with same tables)
Posted by GitBox <gi...@apache.org>.
lilykuang commented on issue #8871:
URL: https://github.com/apache/incubator-superset/issues/8871#issuecomment-632386072
it's probably impossible to remove constraints on some databases. There's some comment from previous issues https://github.com/apache/incubator-superset/issues/5557#issuecomment-410306136. Hope that help
----------------------------------------------------------------
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] mistercrunch commented on issue #8871: Integrity error, probably unique constraint (two mysql databases with same tables)
Posted by GitBox <gi...@apache.org>.
mistercrunch commented on issue #8871:
URL: https://github.com/apache/incubator-superset/issues/8871#issuecomment-632466691
This should help https://github.com/apache/incubator-superset/pull/9882
----------------------------------------------------------------
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 #8871: Integrity error, probably unique constraint (two mysql databases with same tables)
Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #8871:
URL: https://github.com/apache/incubator-superset/issues/8871#issuecomment-663807198
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
[GitHub] [incubator-superset] stale[bot] closed issue #8871: Integrity error, probably unique constraint (two mysql databases with same tables)
Posted by GitBox <gi...@apache.org>.
stale[bot] closed issue #8871:
URL: https://github.com/apache/incubator-superset/issues/8871
----------------------------------------------------------------
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