Superset入坑之sqlalchemy.exc.InvalidRequestError

Superset初始化时报错

sqlalchemy.exc.InvalidRequestError: Can't determine which FROM clause to join from, there are multiple FROMS which can join to this entity. Try adding an explicit ON clause to help resolve the ambiguity.

原因是SQLAlchemy 库版本太高,安装低版本的 SQLAlchemy 库即可解决

(env) root@ubuntu18:/opt/superset_dev#  pip list | grep -i sqlalchemy
Flask-SQLAlchemy       2.4.0    
marshmallow-sqlalchemy 0.16.4   
SQLAlchemy             1.3.5    
SQLAlchemy-Utils       0.34.0   
(env) root@ubuntu18:/opt/superset_dev# pip install SQLAlchemy==1.2.18
Looking in indexes: http://mirrors.cloud.aliyuncs.com/pypi/simple/
Collecting SQLAlchemy==1.2.18
  Downloading http://mirrors.cloud.aliyuncs.com/pypi/packages/21/ed/7eb53305b43ca51774a458d7c292f3bc7664d7a9bbb5bac4149fa34756b9/SQLAlchemy-1.2.18.tar.gz (5.7MB)
     |████████████████████████████████| 5.7MB 1.1MB/s 
Building wheels for collected packages: SQLAlchemy
  Building wheel for SQLAlchemy (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/d8/77/b9/4d5b3a63422b0bb09c39b9d3bdcf81d47233ef0dd111e05ffe
Successfully built SQLAlchemy
Installing collected packages: SQLAlchemy
  Found existing installation: SQLAlchemy 1.3.5
    Uninstalling SQLAlchemy-1.3.5:
      Successfully uninstalled SQLAlchemy-1.3.5
Successfully installed SQLAlchemy-1.2.18
上一篇:Apache老母鸡又下蛋?一文俯瞰Apache Superset


下一篇:Apache老母鸡又下蛋?一文俯瞰Apache Superset