安装准备

1、安装简介

Superset 是 airbnb 开源的一款轻量级的 BI 可视化工具，现已托管在 apache 基金会旗下。本文将在 Ubuntu 18.04 上安装 Superset 并简单体验。

2、安装环境

Ubuntu 18.04.5
Python 3.6.9
Superset 0.37.1

安装步骤

1、创建一个 Python 虚拟环境并激活

$ python3 -m venv venv

示例：

$ pwd       
/home/jiangzl/Workspace/superset
$ python3 -m venv venv
$ source venv/bin/activate

注：

(1) 这种创建虚拟环境的方式仅适用于 Python 3.3 及以上环境，如果是其他版本，建议使用 virtualenv 进行创建，具体方式可自行搜索。

(2) 激活虚拟环境后，使用 pip 安装的所有库只会对该环境有效，能起到环境隔离的作用。

(3) 可以使用 deactivate 退出虚拟环境

2、安装 apache superset

在第一步激活 Python3 虚拟环境条件下，执行如下命令即可安装 superset

pip3 install apache-superset

示例：

(venv) $ pip install apache-superset -i https://pypi.douban.com/simple
...

注：国内用户建议添加 -i 参数指定安装库的源地址 (index-url)，加速安装。

3、初始化数据库

superset db upgrade

示例：

(venv) $ superset db upgrade
logging was configured successfully
INFO:superset.utils.logging_configurator:logging was configured successfully
/home/jiangzl/Workspace/superset-test/venv/lib/python3.6/site-packages/flask_caching/__init__.py:192: UserWarning: Flask-Caching: CACHE_TYPE is set to null, caching is effectively disabled.
  "Flask-Caching: CACHE_TYPE is set to null, "
No PIL installation found
INFO:superset.utils.screenshots:No PIL installation found
WARNI [alembic.env] SQLite Database support for metadata databases will be removed in a future version of Superset.
INFO  [alembic.runtime.migration] Context impl SQLiteImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.

4、创建 admin 角色用户

$ export FLASK_APP=superset
$ superset fab create-admin

示例：

(venv) $ export FLASK_APP=superset
(venv) $ superset fab create-admin
logging was configured successfully
INFO:superset.utils.logging_configurator:logging was configured successfully
/home/jiangzl/Workspace/superset-test/venv/lib/python3.6/site-packages/flask_caching/__init__.py:192: UserWarning: Flask-Caching: CACHE_TYPE is set to null, caching is effectively disabled.
  "Flask-Caching: CACHE_TYPE is set to null, "
No PIL installation found
INFO:superset.utils.screenshots:No PIL installation found
Username [admin]: 
User first name [admin]: 
User last name [user]: 
Email [admin@fab.org]: 
Password: 
Repeat for confirmation: 

创建 admin 用户会让你输入用户相关信息: Username(默认 admin)，User first name(默认 admin)，User last name(默认 user)，Email(默认 admin@fab.org)，这些都可以使用默认直接回车（Enter）即可。Password 请自行设置并记住。

5、导入示例数据

$ superset load_examples

注：如果是在国内，某些区域的 raw.githubusercontent.com 域名 DNS 解析被污染，如果访问不了，请在 /etc/hosts 中添加如下解析

151.101.108.133 raw.githubusercontent.com

这里需要花费比较多时间，因为连接国外服务器较慢。

(venv) $ superset load_examples
logging was configured successfully
INFO:superset.utils.logging_configurator:logging was configured successfully
/home/jiangzl/Workspace/superset/venv/lib/python3.6/site-packages/flask_caching/__init__.py:192: UserWarning: Flask-Caching: CACHE_TYPE is set to null, caching is effectively disabled.
  "Flask-Caching: CACHE_TYPE is set to null, "
No PIL installation found
INFO:superset.utils.screenshots:No PIL installation found
Loading examples metadata and related data into examples
Creating default CSS templates
Loading energy related dataset
Creating table [wb_health_population] reference
Loading [World Bank's Health Nutrition and Population Stats]
Creating table [wb_health_population] reference
Creating slices
Creating a World's Health Bank dashboard
Loading [Birth names]
Done loading table!
--------------------------------------------------------------------------------
Creating table [birth_names] reference
Creating some slices
Creating a dashboard
Loading [Unicode test data]
Done loading table!
--------------------------------------------------------------------------------
...
Creating Scatterplot slice
Creating Screen Grid slice
Creating Hex slice
Creating Grid slice
Creating Polygon slice
Creating Arc slice
Creating Path slice
Creating a dashboard
Loading [Tabbed dashboard]
Creating a dashboard with nested tabs

6、创建角色及权限

执行如下命令 superset init 即可初始化 superset 默认的角色及权限相关的数据并将其写入 SQLite 数据库中。

$ superset init

示例：

(venv) $ superset init
logging was configured successfully
INFO:superset.utils.logging_configurator:logging was configured successfully
/home/jiangzl/Workspace/superset/venv/lib/python3.6/site-packages/flask_caching/__init__.py:192: UserWarning: Flask-Caching: CACHE_TYPE is set to null, caching is effectively disabled.
  "Flask-Caching: CACHE_TYPE is set to null, "
No PIL installation found
INFO:superset.utils.screenshots:No PIL installation found
Syncing role definition
INFO:superset.security.manager:Syncing role definition
Syncing Admin perms
INFO:superset.security.manager:Syncing Admin perms
Syncing Alpha perms
INFO:superset.security.manager:Syncing Alpha perms
Syncing Gamma perms
INFO:superset.security.manager:Syncing Gamma perms
Syncing granter perms
INFO:superset.security.manager:Syncing granter perms
Syncing sql_lab perms
INFO:superset.security.manager:Syncing sql_lab perms
Fetching a set of all perms to lookup which ones are missing
INFO:superset.security.manager:Fetching a set of all perms to lookup which ones are missing
Creating missing datasource permissions.
INFO:superset.security.manager:Creating missing datasource permissions.
Creating missing database permissions.
INFO:superset.security.manager:Creating missing database permissions.
Creating missing metrics permissions
INFO:superset.security.manager:Creating missing metrics permissions
Cleaning faulty perms
INFO:superset.security.manager:Cleaning faulty perms

运行验证

1、superset 运行

$ superset run -p 8088 --with-threads --reload --debugger

示例:

$ nohup superset run -h 0.0.0.0 -p 8088 --with-threads --reload --debugger > superset.log 2>&1 &

2、访问验证

访问 http://ip:port 输入上面创建的 admin 用户进行访问

示例：

安装成功。

附录

参考：

1、superset official doc

https://superset.incubator.apache.org/docs/intro

2、installing from scratch

https://superset.incubator.apache.org/docs/installation/installing-superset-from-scratch