rusthx opened a new issue, #1956: URL: https://github.com/apache/doris-website/issues/1956
Path:/zh-CN/docs/ecosystem/bi/apache-superset 我在使用superset连接Doris时测试连接成功，但是连接时报错创建数据源失败。查看superset日志显示报错为 ``` 2025-01-31 16:08:13,496 ERROR flask_appbuilder.api MainThread : (MySQLdb.OperationalError) (1105, 'errCode = 2, detailMessage = No catalog found with name America_taxi') [SQL: SHOW schemas FROM `America_taxi`] (Background on this error at: https://sqlalche.me/e/14/e3q8) Traceback (most recent call last): File "/home/rust/superset/lib/python3.10/site-packages/flask_appbuilder/api/__init__.py", line 110, in wraps return f(self, *args, **kwargs) File "/home/rust/superset/lib/python3.10/site-packages/superset/views/base_api.py", line 127, in wraps raise ex File "/home/rust/superset/lib/python3.10/site-packages/superset/views/base_api.py", line 121, in wraps duration, response = time_function(f, self, *args, **kwargs) File "/home/rust/superset/lib/python3.10/site-packages/superset/utils/core.py", line 1526, in time_function response = func(*args, **kwargs) File "/home/rust/superset/lib/python3.10/site-packages/superset/utils/log.py", line 255, in wrapper value = f(*args, **kwargs) File "/home/rust/superset/lib/python3.10/site-packages/superset/views/base_api.py", line 93, in wraps return f(self, *args, **kwargs) File "/home/rust/superset/lib/python3.10/site-packages/superset/databases/api.py", line 371, in post new_model = CreateDatabaseCommand(item).run() File "/home/rust/superset/lib/python3.10/site-packages/superset/databases/commands/create.py", line 109, in run schemas = database.get_all_schema_names(cache=False, ssh_tunnel=ssh_tunnel) File "/home/rust/superset/lib/python3.10/site-packages/superset/utils/cache.py", line 130, in wrapped_f return f(*args, **kwargs) File "/home/rust/superset/lib/python3.10/site-packages/superset/models/core.py", line 777, in get_all_schema_names raise self.db_engine_spec.get_dbapi_mapped_exception(ex) from ex File "/home/rust/superset/lib/python3.10/site-packages/superset/models/core.py", line 775, in get_all_schema_names return self.db_engine_spec.get_schema_names(inspector) File "/home/rust/superset/lib/python3.10/site-packages/superset/db_engine_specs/base.py", line 1197, in get_schema_names return sorted(inspector.get_schema_names()) File "/home/rust/superset/lib/python3.10/site-packages/sqlalchemy/engine/reflection.py", line 237, in get_schema_names return self.dialect.get_schema_names( File "/home/rust/superset/lib/python3.10/site-packages/pydoris/sqlalchemy/dialect.py", line 157, in get_schema_names rp = connection.exec_driver_sql("SHOW schemas FROM %s" File "/home/rust/superset/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1638, in exec_driver_sql return self._exec_driver_sql( File "/home/rust/superset/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1547, in _exec_driver_sql ret = self._execute_context( File "/home/rust/superset/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1814, in _execute_context self._handle_dbapi_exception( File "/home/rust/superset/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1995, in _handle_dbapi_exception util.raise_( File "/home/rust/superset/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 207, in raise_ raise exception File "/home/rust/superset/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1771, in _execute_context self.dialect.do_execute( File "/home/rust/superset/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute cursor.execute(statement, parameters) File "/home/rust/superset/lib/python3.10/site-packages/MySQLdb/cursors.py", line 179, in execute res = self._query(mogrified_query) File "/home/rust/superset/lib/python3.10/site-packages/MySQLdb/cursors.py", line 330, in _query db.query(q) File "/home/rust/superset/lib/python3.10/site-packages/MySQLdb/connections.py", line 255, in query _mysql.connection.query(self, query) sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (1105, 'errCode = 2, detailMessage = No catalog found with name America_taxi') [SQL: SHOW schemas FROM `America_taxi`] (Background on this error at: https://sqlalche.me/e/14/e3q8) ``` 解决方案：使用支持 Doris 的 sqlalchemy-doris 驱动 `pip install sqlalchemy-doris` 另外，我使用superset连接Doris时发现没有文档中的界面，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. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
