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 2022/11/24 05:59:30 UTC
[GitHub] [superset] AnanthaGopi0 opened a new issue, #22215: Microsoft SQL server as metadata is not suppoted
AnanthaGopi0 opened a new issue, #22215:
URL: https://github.com/apache/superset/issues/22215
but I am getting errors doing the "Superset DB upgrade".
sqlalchemy.exc.ProgrammingError: (pymssql._pymssql.ProgrammingError) (208, b"Invalid object name 'alembic_version'.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n")
[SQL: UPDATE alembic_version SET version_num='b4456560d4f3' WHERE alembic_version.version_num = 'bb51420eaf83']
is there any alternate solution for that to configure the mssql server as metadata to the superset.
- browser type and version:
- superset version: 1.3.0
- python version: 3.8.8
- node.js version:
- any feature flags active: THUMBNAILS, ALERT_REPORTS, VERSIONED_EXPORT
### Checklist
Make sure to follow these steps before submitting your issue - thank you!
- [ok ] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [ok ] I have reproduced the issue with at least the latest released version of superset.
- [[ok](url) ] I have checked the issue tracker for the same issue and I haven't found one similar.
Add any other context about the problem here.
--
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] sfirke commented on issue #22215: Microsoft SQL server as metadata is not suppoted
Posted by GitBox <gi...@apache.org>.
sfirke commented on issue #22215:
URL: https://github.com/apache/superset/issues/22215#issuecomment-1366719393
No, MSSQL is not supported as a metadata DB. See this FAQ: https://superset.apache.org/docs/frequently-asked-questions/#what-database-engine-can-i-use-as-a-backend-for-superset
> Superset is tested using Mysql, Postgresql and Sqlite for its backend. It’s recommended you install Superset on one of these database server for production.
> Using a column-store, non-OLTP databases like Vertica, Redshift or Presto as a database backend simply won’t work as these databases are not designed for this type of workload. **Installation on Oracle, Microsoft SQL Server, or other OLTP databases may work but isn’t tested.**
Since this isn't a bug, I believe this issue should be closed. You could create a Feature Request in the Github Discussions for this functionality but realistically, I don't think any existing contributors are likely to prioritize it. Your best bet is to use MySQL or Postgres for the backend 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.
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] rusackas closed issue #22215: Microsoft SQL server as metadata is not suppoted
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #22215: Microsoft SQL server as metadata is not suppoted
URL: https://github.com/apache/superset/issues/22215
--
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