dosubot[bot] commented on issue #34072: URL: https://github.com/apache/superset/issues/34072#issuecomment-3036732111
<!-- Answer --> Thanks for confirming pydoris is installed and the connection string is correct. Superset 5.0.0 is designed to use pydoris for Doris connections, and there are no known compatibility issues or breaking changes in this area—if you see MySQLdb.OperationalError, it usually means Superset is falling back to a MySQL driver, often because pydoris isn’t being picked up by SQLAlchemy as expected[^1][^2]. A few things to check: - Make sure the Python environment running Superset is the same one where you installed pydoris (sometimes there are multiple environments or virtualenv confusion). - Double-check that the connection URI in Superset’s database config is exactly doris:// or pydoris:// (not mysql://). - Try restarting all Superset processes after upgrading pydoris to ensure the new driver is loaded. - If possible, run a quick SQLAlchemy test outside Superset to confirm pydoris is registered and can connect. If you can, grab the detailed Superset logs for a failed Doris query—sometimes the stacktrace gives more clues about where the fallback is happening. [^1]: [DorisEngineSpec always uses pydoris for doris:// or pydoris:// URIs](https://github.com/apache/superset/blob/ef14a5fbb47a540b0c91f40fa397fa9c6d18fa2d/superset/db_engine_specs/doris.py) [^2]: [No recent changes in Superset 5.0.0 affect Doris driver selection](https://github.com/apache/superset/blob/ef14a5fbb47a540b0c91f40fa397fa9c6d18fa2d/CHANGELOG/5.0.0.md) <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/ff4c202e-c493-4a73-8e8b-93a6c58a3b41?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/ff4c202e-c493-4a73-8e8b-93a6c58a3b41?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/ff4c202e-c493-4a73-8e8b-93a6c58a3b41?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/ff4c202e-c493-4a73-8e8b-93a6c58a3b41?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/ff4c202e-c493-4a73-8e8b-93a6c58a3b41?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/ff4c202e-c493-4a73-8e8b-93a6c58a3b41?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/ff4c202e-c493-4a73-8e8b-93a6c58a3b41?feedback_type=other)</sup> [](https://go.dosu.dev/discord-bot) [! [Share on X](https://img.shields.io/badge/X-share-black)](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/issues/34072) -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
