基于docker安装superset

superset简介

曾用名Caravel, Panoramix, 是由Airbnb（知名在线房屋短租公司）开源的数据分析与可视化平台, 该工具主要特点是可自助分析, 自定义仪表盘, 分析结果可视化（导出）, 用户/角色权限控制, 还集成了一个SQL编辑器, 可以进行SQL编辑查询等。

superset安装

查看已安装docker版本

[root@Ieat2 ~]# docker version Client: Version: 17.03.2-ce API version: 1.27 Go version: go1.7.5 Git commit: f5ec1e2 Built: Tue Jun 27 02:21:36 2017 OS/Arch: linux/amd64 Server: Version: 17.03.2-ce API version: 1.27 (minimum version 1.12) Go version: go1.7.5 Git commit: f5ec1e2 Built: Tue Jun 27 02:21:36 2017 OS/Arch: linux/amd64 Experimental: false 

拉取镜像superset镜像

docker pull amancevice/superset 

创建superset容器（让容器中的superset挂载本地机的配置文件）

docker run -d -p 8088:8088 -v /opt/docker/superset:/home/superset --name superset amancevice/superset 

查看容器

[root@Ieat2 ~]# docker ps |grep superset a27705e43255 amancevice/superset "gunicorn superset..." 3 hours ago Up 3 hours (healthy) 0.0.0.0:8088->8088/tcp superset 

配置superset容器
设置用户名和密码(docker exec -it 容器ID fabmanager create-admin –app superset)
初始化数据库（docker exec -it 容器ID superset db upgrade）
superset初始化（docker exec -it 容器ID superset init）
开启superset服务（docker exec -it 容器ID superset runserver）

[root@Ieat2 ~]# docker exec -it superset fabmanager create-admin --app superset Username [admin]: test User first name [admin]: test User last name [user]: test Email [admin@fab.org]: xxx@qq.com Password: Repeat for confirmation: Recognized Database Authentications. Admin User makai created. [root@Ieat2 ~]# docker exec -it superset superset db upgrade INFO [alembic.runtime.migration] Context impl SQLiteImpl. INFO [alembic.runtime.migration] Will assume transactional DDL. INFO [alembic.runtime.migration] Running upgrade -> 4e6a06bad7a8, Init ... ...... [root@Ieat2 ~]# docker exec -it superset superset init 2018-08-19 16:21:55,189:INFO:root:Syncing role definition 2018-08-19 16:21:55,190:INFO:root:Creating database reference 2018-08-19 16:21:55,256:INFO:root:Syncing Admin perms 2018-08-19 16:21:55,358:INFO:root:Syncing Alpha perms 2018-08-19 16:21:55,833:INFO:root:Syncing Gamma perms 2018-08-19 16:21:56,204:INFO:root:Syncing granter perms 2018-08-19 16:21:56,594:INFO:root:Syncing sql_lab perms 2018-08-19 16:21:57,072:INFO:root:Fetching a set of all perms to lookup which ones are missing 2018-08-19 16:21:57,167:INFO:root:Creating missing datasource permissions. 2018-08-19 16:21:57,177:INFO:root:Creating missing database permissions. 2018-08-19 16:21:57,198:INFO:root:Creating missing metrics permissions [root@Ieat2 ~]# docker exec -it superset superset runserver 

访问superset http://localhost:8088

设置中文界面