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