Superset 踩坑汇总

on Note

帮同事搭建 Superset 时遇到的问题。

  1. 查询数据日文显示乱码

    解决方案:

    连接mysql的时候一定要加charset=utf8

  2. SQL_lab :: Results backend isn't configured 详情参见 issue1984

    解决方案:

    配置文件中添加

     from werkzeug.contrib.cache import FileSystemCache
 RESULTS_BACKEND = FileSystemCache('/tmp/sqllab_cache', default_timeout=60*24*7)

  3. This functionality has been disabled for security reasons

    解决方案:

    Set ENABLE_JAVASCRIPT_CONTROLS = True in your superset_config.py

    详见 issue5396

  4. 上传文件报错：权限不足。

    解决方案:

     BASE_DIR = os.path.abspath(os.path.dirname(__file__))

 # The file upload folder, when using models with files
 UPLOAD_FOLDER = BASE_DIR + '/app/static/uploads/'

 # The image upload folder, when using models with images
 IMG_UPLOAD_FOLDER = BASE_DIR + '/app/static/uploads/'