简单好用的superset可视化工具

1、Docker在线环境安装（可参考）：

1. 卸载已有docker环境

yum remove docker \
                  docker-client \
                  docker-client-latest \
                  docker-common \
                  docker-latest \
                  docker-latest-logrotate \
                  docker-logrotate \
                  docker-engine

1. 2、 安装软件包

yum install -y yum-utils \
  device-mapper-persistent-data \
  lvm2

1. 设置国内镜像源

yum-config-manager --add-repo  https://mirrors.tuna.tsinghua.edu.cn/docker-ce/linux/centos/docker-ce.repo

或者

yum-config-manager --add-repo https://mirrors.ustc.edu.cn/docker-ce/linux/centos/docker-ce.repo

安装docker-ce

yum install docker-ce docker-ce-cli containerd.io

启动docker

systemctl enable docker

systemctl start docker

2、docker离线安装（自行下载docker部署包）：

1、下载安装包

wget https://download.docker.com/linux/static/stable/x86_64/docker-20.10.7.tgz

2、解压  tar xf docker-20.10.7.tgz

3、cp docker/* /usr/bin/

4、docker.server的配置

vi /usr/lib/systemd/system/docker.service

[Unit]

Description=Docker Application Container Engine

Documentation=https://docs.docker.com

After=network-online.target firewalld.service

Wants=network-online.target

[Service]

Type=notify

# the default is not to use systemd for cgroups because the delegate issues still

# exists and systemd currently does not support the cgroup feature set required

# for containers run by docker

ExecStart=/usr/bin/dockerd -H tcp://0.0.0.0:2375 -H unix://var/run/docker.sock

ExecReload=/bin/kill -s HUP $MAINPID

# Having non-zero Limit*s causes performance problems due to accounting overhead

# in the kernel. We recommend using cgroups to do container-local accounting.

LimitNOFILE=infinity

LimitNPROC=infinity

LimitCORE=infinity

# Uncomment TasksMax if your systemd version supports it.

# Only systemd 226 and above support this version.

#TasksMax=infinity

TimeoutStartSec=0

# set delegate yes so that systemd does not reset the cgroups of docker containers

Delegate=yes

# kill only the docker process, not all processes in the cgroup

KillMode=process

# restart the docker process if it exits prematurely

Restart=on-failure

StartLimitBurst=3

StartLimitInterval=60s

[Install]

WantedBy=multi-user.target

5、启动dockerd服务进程

systemctl daemon-reload

systemctl restart docker

systemctl enable docker

6、查看 docker -v

3、Superset部署步骤：

导入superset 镜像包 ，镜像包名称为：superset.tar（如果可以连网，直接docker pull amancevice/superset，不用导入镜像）

1. ）

指令：docker load < superset.tar

导入后查询，指令：docker images，查找是否有amancevice/superset

1. 启动镜像

docker run -d -p 9088:8088 -v /home/zeroMaster/software/superset:/home/superset amancevice/superset

9088 宿主机端口，用于对外访问  8088默认镜像端口

/home/zeroMaster/software/superset  宿主机挂载路径（自己创建即可）

        查看是否启动成功：

        docker ps

1. 创建账号

进入docker 运行实例内：

docker exec -it ac1da5ecd1d8 /bin/bash

1. 数据库更新：superset db upgrade
2. 创建账号：

export FLASK_APP=superset

flask fab create-admin

1. 初始化：      superset init        忽略告警
2. 启动：        superset run
3. 数据库：
4. 加载默认数据：superset load_examples

1. 更改中文界面

进入/usr/local/lib/python3.8/site-packages/superset目录

Vim config.py

执行

pybabel compile -d translations

如果要使用upload功能，将superset这个路径，新增权限

cd /usr/local/lib/python3.8/site-packages/

chown –R superset superset

1. 退出 镜像

exit

重启镜像

docker stop ac1da5ecd1d8

docker start ac1da5ecd1d8

1. 登入

http：//ip:9088

root权限：

docker exec -it --user root d55e1510e608 /bin/bash

apt-get update