SQL向：在 mac 上搭建 superset 环境

基本安装步骤 

1. 安装 pip；
sudo easy_install pip

2. 安装 virtualenv；
pip install virtualenv

3. 安装 superset；
pip install virtualenv

4. 初始化数据库；
superset db upgrade

5. 创建一个 admin 用户
$ export FLASK_APP=superset
fabmanager create-admin --app superset

6. 加载一些examples
superset load_examples

7. 初始化一些默认权限
superset init

8. 然后就可以开启服务了，根据结果返回的地址访问即可
superset runserver

 

过程中遇到的问题

1. superset db upgrade 中报错 ImportError: cannot import name '_maybe_box_datetimelike' from 'pandas.core.common' (/Users/pengyuyan/env_name/lib/python3.7/site-packages/pandas/core/common.py)

   #解决办法
   pip uninstall pandas
   pip install pandas==0.23.4

2. superset db upgrade 中报错 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.

   #解决办法
   pip install sqlalchemy==1.2.18