superset 出现数据库错误

最新推荐文章于 2025-05-30 09:03:36 发布

远古小山

最新推荐文章于 2025-05-30 09:03:36 发布

阅读量6.9k

点赞数

CC 4.0 BY-SA版权

分类专栏： superset

本文链接：https://blog.csdn.net/zhulei19931019/article/details/78074788

在尝试升级Superset到0.19.1版本时，发现汉化效果不佳。通过对比发现发行版与GitHub的develop分支存在差异。为保持代码与数据库同步，采取了两种方法：一是将develop分支的迁移文件覆盖到系统版本并执行`superset db upgrade`；二是通过设置SUPERSET_HOME使用develop分支的数据库路径。执行相关命令后，成功升级Superset。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

出错log：

sqlalchemy.exc.OperationalError
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: dbs.impersonate_user 
[SQL: 'SELECT dbs.created_on AS dbs_created_on, dbs.changed_on AS dbs_changed_on, dbs.id AS dbs_id, dbs.verbose_name AS dbs_verbose_name, dbs.database_name AS dbs_database_name, dbs.sqlalchemy_uri AS dbs_sqlalchemy_uri, dbs.password AS dbs_password, dbs.cache_timeout AS dbs_cache_timeout, dbs.select_as_create_table_as AS dbs_select_as_create_table_as, dbs.expose_in_sqllab AS dbs_expose_in_sqllab, dbs.allow_run_sync AS dbs_allow_run_sync, dbs.allow_run_async AS dbs_allow_run_async, dbs.allow_ctas AS dbs_allow_ctas, dbs.allow_dml AS dbs_allow_dml, 
dbs.force_ctas_schema AS dbs_force_ctas_schema, dbs.extra AS dbs_extra, dbs.perm AS dbs_perm, 
dbs.impersonate_user AS dbs_impersonate_user, dbs.created_by_fk AS dbs_created_by_fk, 
dbs.cha