一. Superset安装(windows)

1. 安装环境

win10, pycharm
Superset最佳实践是在Docker中安装部署，本次学习在win中进行。

2. 新建项目

a)用pycharm直接新建，省时省力
pip install apache-superset

b)如不借助于IDE，创建虚拟环境，激活，安装
python3 -m venv projectname
source projectname/bin/activate
pip install apache-superset

3. 初始化

创建用户，依次为用户名，姓，名，邮箱，密码及确认
fabmanager create-admin --app superset

初始化数据库
superset db upgrade

载入测试数据
superset load_examples

初始化角色和权限
superset init

4. 启动服务

superset runserver
可加参数 -p xxxx 修改端口，默认8088
win下换成 flask run -p 8088 --with-threads --reload --debugger
或者superset run

trouble&shooting

1.
报错：
执行fabmanager create-admin --app superset时报错AttributeError: 'NoneType' object has no attribute 'auth_type'
详情：

Traceback (most recent call last):
  File "C:\Users\Administrator\AppData\Local\Programs\Python\Python37\lib\runpy.py", line 193, in _run_module_as_main "__main__", mod_spec)
  File "C:\Users\Administrator\AppData\Local\Programs\Python\Python37\lib\runpy.py", line 85, in _run_code exec(code, run_globals)
  File "C:\Users\Administrator\Desktop\SuperSet\venv\Scripts\fabmanager.exe\__main__.py", line 7, in <module>
  File "c:\users\administrator\desktop\superset\venv\lib\site-packages\flask_appbuilder\console.py", line 422, in cli cli_app()
  File "c:\users\administrator\desktop\superset\venv\lib\site-packages\click\core.py", line 829, in __call__ return self.main(*args, **kwargs)
  File "c:\users\administrator\desktop\superset\venv\lib\site-packages\click\core.py", line 782, in main rv = self.invoke(ctx)
  File "c:\users\administrator\desktop\superset\venv\lib\site-packages\click\core.py", line 1259, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "c:\users\administrator\desktop\superset\venv\lib\site-packages\click\core.py", line 1066, in invoke return ctx.invoke(self.callback, **ctx.params)
  File "c:\users\administrator\desktop\superset\venv\lib\site-packages\click\core.py", line 610, in invoke return callback(*args, **kwargs)
  File "c:\users\administrator\desktop\superset\venv\lib\site-packages\flask_appbuilder\console.py", line 137, in create_admin auth_type.get(_appbuilder.sm.auth_type, "No Auth method")
AttributeError: 'NoneType' object has no attribute 'auth_type'

解决：
从网上找的解决方案，主要在于版本不兼容，降级Superset版本。我这边的解决方案是：
根据一直提示的fabmanager is going to be deprecated in 2.2.X, you can use the same commands on the improved 'flask fab <command>'，猜想用最新的命令也许有效，蒙对了。
先cd到superset包安装路径
cd venv\Lib\site-packages\superset
再用新命令创建账号，根据提示输入姓、名、邮箱，提示admin账号创建成功。
flask fab create-admin --username admin --password 123456