Docker 安装Apache Superset 并实现汉化和快速入门

心已赠人 2024-04-23 16:00 5阅读 0赞

## 什么是Apache Superset ##

Apache Superset是一个现代化的企业级商业智能Web应用程序。Apache Superset 支持用户的各种数据类型可视化和数据分析，支持简单图饼图到复杂的地理空间图表。Apache Superset 是一个轻量级、简单化、直观化、可配置的BI 框架。

## Docker 安装Apache Superset ##

**Docker 检索 superse**

[root@localhost ~]# docker search superset
    NAME                                   DESCRIPTION                                     STARS               OFFICIAL            AUTOMATED
    amancevice/superset                    Superset on Debian+Python3                      278                                     [OK]
    apache/superset                        Apache Superset                                 238
    ******

**Docker 下载并查看superset镜像**

[root@localhost ~]# docker pull apache/superset
    Using default tag: latest
    latest: Pulling from apache/superset
    0e29546d541c: Pull complete
    9b829c73b52b: Pull complete
    cb5b7ae36172: Pull complete
    6494e4811622: Pull complete
    ******

[root@localhost ~]# docker images
    REPOSITORY           TAG                 IMAGE ID            CREATED             SIZE
    nginx                latest              0e901e68141f        18 months ago       142MB
    mysql                5.7                 2a0961b7de03        18 months ago       462MB
    apache/superset      latest              3e8fac582908        23 months ago       1.69GB
    ******

**创建superset 挂载目录：/opt/superset**

[root@localhost opt]# mkdir /opt/superset

**运行superset 容器**

[root@localhost opt]# docker run --name my_superset -d -p 8088:8088 -v /opt/superset:/home/superset apache/superset
    8797809b77f275d4655d9bc80a1e7f227330a0973bf6ab7d1031be7a0e70b54d

**查看正在运行容器**

[root@localhost opt]# docker ps
    CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS                    PORTS                                                  NAMES
    8797809b77f2        apache/superset     "/bin/sh -c /usr/bin…"   43 seconds ago      Up 42 seconds (healthy)   0.0.0.0:8088->8088/tcp                                 my_superset
    ******

**进入superset镜像**

[root@localhost opt]# docker exec -it my_superset /bin/bash

**superset 数据库初始化**

superset@8797809b77f2:/app$ superset db upgrade
    logging was configured successfully
    2023-12-07 15:25:41,240:INFO:superset.utils.logging_configurator:logging was configured successfully
    2023-12-07 15:25:41,259:INFO:root:Configured event logger of type <class 'superset.utils.log.DBEventLogger'>
    /usr/local/lib/python3.8/site-packages/flask_caching/__init__.py:201: UserWarning: Flask-Caching: CACHE_TYPE is set to null, caching is effectively disabled.
      warnings.warn(
    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.
    ******

**superset 应用初始化**

superset@8797809b77f2:/app$ superset init
    logging was configured successfully
    2023-12-07 15:26:15,395:INFO:superset.utils.logging_configurator:logging was configured successfully
    2023-12-07 15:26:15,411:INFO:root:Configured event logger of type <class 'superset.utils.log.DBEventLogger'>
    /usr/local/lib/python3.8/site-packages/flask_caching/__init__.py:201: UserWarning: Flask-Caching: CACHE_TYPE is set to null, caching is effectively disabled.
      warnings.warn(
    Syncing role definition
    2023-12-07 15:26:32,491:INFO:superset.security.manager:Syncing role definition
    Syncing Admin perms
    ******

**superset 设置管理员账户**

superset@8797809b77f2:/app$ export FLASK_APP=superset
    superset@8797809b77f2:/app$ flask fab create-admin
    Username [admin]: admin
    User first name [admin]: first
    User last name [user]: last
    Email [admin@fab.org]: admin@test.com
    Password:
    Repeat for confirmation:
    logging was configured successfully
    2023-12-07 15:28:24,832:INFO:superset.utils.logging_configurator:logging was configured successfully
    ******

温馨提示：设置superset 管理员账户为:admin 密码:123456  
**加载superset 示例Demo**

superset@8797809b77f2:/app$ superset load_examples
    logging was configured successfully
    2023-12-07 15:29:03,488:INFO:superset.utils.logging_configurator:logging was configured successfully
    2023-12-07 15:29:03,501:INFO:root:Configured event logger of type <class 'superset.utils.log.DBEventLogger'>
    /usr/local/lib/python3.8/site-packages/flask_caching/__init__.py:201: UserWarning: Flask-Caching: CACHE_TYPE is set to null, caching is effectively disabled.
      warnings.warn(
    Creating database reference for examples
    2023-12-07 15:29:07,167:INFO:superset.utils.core:Creating database reference for examples
    Loading examples metadata and related data into examples
    Creating default CSS templates
    Loading [World Bank's Health Nutrition and Population Stats]
    Traceback (most recent call last):
      File "/usr/local/lib/python3.8/urllib/request.py", line 1354, in do_open
        h.request(req.get_method(), req.selector, req.data, headers,
      File "/usr/local/lib/python3.8/http/client.py", line 1256, in request
        self._send_request(method, url, body, headers, encode_chunked)
    ******

温馨提示:由于Paython 版本对语法支持差异，示例Demo会报错，但不会影响我们的使用。

**superset 管理平台访问**

![339f8a5b661a4bb199d12e0db7bef31d.png][]

## Apache Superset 汉化 ##

核心命令：

# 进入superset 镜像
    docker exec -it -u root my_superset /bin/bash
    # 替换/app/superset/config.py 配置文件
    sed -i "s/BABEL_DEFAULT_LOCALE = \"en/BABEL_DEFAULT_LOCALE = \"zh/g" superset/config.py
    #  替换/app/superset/config.py 配置文件
    sed -i "s/LANGUAGES = {}/# LANGUAGES = {}/g" superset/config.py
    
    #重新启动superset 镜像
    docker restart my_superset

**superset 汉化界面**

![71ee56f18323419a89288d6b523e2f34.png][]

## Apache Superset 快速入门 ##

**第一步：添加Databases(数据库)**

![9f237d288ae84ebcbe6a6c6c088d6dc3.png][]

提示:本次演示添加数据库为MySQL 8

![9b3d63c864714c33bf2351bd3d97702e.png][]

填充 MYSQL 8 数据库连接信息

![e7d1a8d9cc1a491e845a6edad7d5ae80.png][]

最后数据库查询列表展示我新增的MYSQL 8 数据库。

![69c5daa2addc4ec89776f2423520ac93.png][]

**第二步：添加Datasets(数据级)**

![3e33eb4aa35c425787ae838abf99b044.png][]

填充 Dataset/数据级信息

![499d03c49d4f4412aed9c29578990993.png][]

最后数据级查询列表展示我新增的base\_building数据级。

![d9be0b249a6743cab927380601989138.png][] **第三步：点击Datasets(数据级) ，创建Chart(图表)**

默认初始化Chart (图表)编辑页面

![4f90dde2e0a844718eecbfb9319283b5.png][]

我基于base\_building/数据集创建查询building\_no\\building\_name\\building\_address的图表.

![1f5746a53bc4465297323624f83d09ed.png][]

**第四步：查询Chart(图表)，并在DashBoard(仪表盘)中显示。**

查询自己创建的Chart图表

![4f840dd13b21450e8670ac95accf5dfd.png][]

新增**看板** ,选择创建的图表

![b783d3c39f364a35a60dc90f50fd55d4.png][]

最终效果展示:

![90c362130d2c46d1af63e172d4578062.png][]

**参考资料：**

Apache Superset 官网：[https://superset.apache.org/docs/intro][https_superset.apache.org_docs_intro]

Apache Superset GitHub 地址 : [https://github.com/apache/superset][https_github.com_apache_superset]  
  
[SuperSet 最新 Docker 部署文档（含元数据库切换、汉化、镜像导出）][SuperSet _ Docker]

[339f8a5b661a4bb199d12e0db7bef31d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/23/95291f27dc934397a366c3b295f3e34f.png
[71ee56f18323419a89288d6b523e2f34.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/23/c93a36c7e77b41aa929d84f71b49cee7.png
[9f237d288ae84ebcbe6a6c6c088d6dc3.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/23/dc10252fe9ac4961b61135a2fb7e9c67.png
[9b3d63c864714c33bf2351bd3d97702e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/23/86e9103267f842079286f8a4e4bd2f21.png
[e7d1a8d9cc1a491e845a6edad7d5ae80.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/23/fff6d2f06bb8419a92d4661541cc5636.png
[69c5daa2addc4ec89776f2423520ac93.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/23/10e7268d5514431c833d319e9c22225c.png
[3e33eb4aa35c425787ae838abf99b044.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/23/1138a8aaac0d4f3aabd37db6a8c54853.png
[499d03c49d4f4412aed9c29578990993.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/23/b57864a7b49542ff8e67515b672ebfc6.png
[d9be0b249a6743cab927380601989138.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/23/1452c101f5e24caca0b69dd3d3fb1d2c.png
[4f90dde2e0a844718eecbfb9319283b5.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/23/a24579d1abeb41829ea4c96a8f0b2ade.png
[1f5746a53bc4465297323624f83d09ed.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/23/98362d75484942e9a4e48ac02a209d33.png
[4f840dd13b21450e8670ac95accf5dfd.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/23/d617b4876476470bb1055682c9f86d60.png
[b783d3c39f364a35a60dc90f50fd55d4.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/23/b4387b5f482640bb934bd3b45fcfb456.png
[90c362130d2c46d1af63e172d4578062.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/23/08b34246185646138ff76bc84a21e4f2.png
[https_superset.apache.org_docs_intro]: https://superset.apache.org/docs/intro
[https_github.com_apache_superset]: https://github.com/apache/superset
[SuperSet _ Docker]: https://blog.csdn.net/ManWZD/article/details/122596308