superset遇到的问题

1、初始化superset时，若提示：UserWarning: Flask-Caching: CACHE_TYPE is set to null, caching is effectively disabled.

找到

python3.6/site-packages/superset/config.py

打开编辑：

THUMBNAIL_CACHE_CONFIG: CacheConfig = {"CACHE_TYPE": "null"}
修改为
THUMBNAIL_CACHE_CONFIG: CacheConfig = {"CACHE_TYPE": "null", "CACHE_NO_NULL_WARNING": True}


CACHE_CONFIG: CacheConfig = {"CACHE_TYPE": "null"}
TABLE_NAMES_CACHE_CONFIG: CacheConfig = {"CACHE_TYPE": "null"}
修改为
CACHE_CONFIG: CacheConfig = {"CACHE_TYPE": "simple"}
TABLE_NAMES_CACHE_CONFIG: CacheConfig = {"CACHE_TYPE": "simple"}
           

2、初始化superset时，若提示：No PIL installation found

pip3 install Pillow

3、输入flask fab create-admin时，报Error: No such command "fab"错

如果你用了Virtualenv，那检查你当前是否在虚拟环境下执行

4、输入flask fab create-admin时，报Could not import "superset.superset"错

进入

python3.6/site-packages/superset/bin

目录下执行

python superset fab create-admin
           

5、输入python superset fab create-admin时，报IndentationError: unexpected indent错

并指出错误在：

File "/root/data/mypy/venv3/lib/python3.8/site-packages/superset/config.py", line 156
    SQLALCHEMY_DATABASE_URI = 'mysql://user:[email protected]/superset?charset=utf8'
    ^
           

那就好好检查之前在config.py中添加的SQLALCHEMY_DATABASE_URI是否有错误，或者前后有多余的空格

6、输入python superset fab create-admin时，报ModuleNotFoundError: No module named 'MySQLdb’错

这是个常见的问题，在错误提示中找到出问题的文件添加

import pymysql
pymysql.install_as_MySQLdb()