Docker快速搭建Superset

最新推荐文章于 2023-11-21 15:32:34 发布
最新推荐文章于 2023-11-21 15:32:34 发布
阅读量1.1k 收藏 3
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_45070407/article/details/104677390
版权

安装前准备

  • docker安装
[root@bogon /]# docker version
Client: Docker Engine - Community
 Version:           19.03.6
 API version:       1.40
 Go version:        go1.12.16
 Git commit:        369ce74a3c
 Built:             Thu Feb 13 01:29:29 2020
 OS/Arch:           linux/amd64
 Experimental:      false

Server: Docker Engine - Community
 Engine:
  Version:          19.03.6
  API version:      1.40 (minimum version 1.12)
  Go version:       go1.12.16
  Git commit:       369ce74a3c
  Built:            Thu Feb 13 01:28:07 2020
  OS/Arch:          linux/amd64
  Experimental:     false
 containerd:
  Version:          1.2.10
  GitCommit:        b34a5c8af56e510852c35414db4c1f4fa6172339
 runc:
  Version:          1.0.0-rc8+dev
  GitCommit:        3e425f80a8c931f88e6d94a8c831b9d5aa481657
 docker-init:
  Version:          0.18.0
  GitCommit:        fec3683

Superset下载

  • 查找superset镜像 docker search superset
[root@bogon ~]# docker search superset
NAME                               DESCRIPTION                                     STARS               OFFICIAL            AUTOMATED
amancevice/superset                Superset on Debian+Python3                      223                                     [OK]
tylerfowler/superset               An extendable Docker image for Airbnb's Supe…   15                                      
crobox/superset                    Superset + Clickhouse docker image              3                                       [OK]
maedamikio/superset                                                                3                                       
preset/superset                    Apache Superset (incubating) is a modern, en…   2                                       
dailyhotel/superset                Dockerized Superset                             2                                       [OK]
ganshanshan/superset_tddv          tddv superset                                   2                                       [OK]
kyligence/superset-kylin           Kyligence Insight for Superset                  2                                       
tyyzqmf/superset                   根据amancevice/superset修改的镜像 主要解决su…              2                                       [OK]
huksley/superset                   AirBnB Superset 0.28 with MySQL driver          2                                       [OK]
noenv/superset                     Superset Docker Image                           1                                       [OK]
pietrocannalire/superset           Superset Image                                  1                                       [OK]
starburstdata/superset             Apache Superset docker container                1                                       [OK]
muicoder/superset                  Superset is a data exploration platform desi…   1                                       [OK]
mmontagna/superset-docker          superset-docker                                 0                                       
burtdatacloud/superset-mysql       Superset MySQL                                  0                                       
gavrikov/superset                                                                  0                                       
dockerdegbert/superset                                                             0                                       
swapnilril/superset160919          Superset on k8s                                 0                                       
ganshanshan/superset1              superset1                                       0                                       [OK]
chethanuk/superset                                                                 0                                       
nis365/superset                    This docker image is built from amancevice/s…   0                                       
wiktor/superset-worker-python2.7                                                   0                                       
lrosenman/superset                 superset                                        0                                       
harisekhon/superset                Superset open source analytics UI by AirBNB     0                                       [OK]
  • 下载superset镜像 docker pull amancevice/superset
[root@bogon ~]# docker pull amancevice/superset
Using default tag: latest
latest: Pulling from amancevice/superset
8f0fdd3eaac0: Downloading [===>                                               ]  3.578MB/50.38MB
d918eaefd9de: Downloading [====================>                              ]  3.144MB/7.812MB
43bf3e3107f5: Downloading [===============>                                   ]  3.062MB/9.996MB
27622921edb2: Waiting 
dcfa0aa1ae2c: Waiting 
ca7e1bbea389: Waiting 
5bf324b44232: Waiting 
a2d410a0f39c: Waiting 
59b774443140: Waiting 
29b9053c8932: Waiting 
d94474b2d644: Waiting 
42b63e1d3d97: Waiting 
a7342379b9b6: Waiting
  • 下载完成后查看下载镜像 docker images
[root@bogon ~]# docker images
REPOSITORY            TAG                 IMAGE ID            CREATED             SIZE
amancevice/superset   latest              796cfafa63e2        6 weeks ago         1.8GB

Docker启动Superset并配置

  • 启动Superset容器 docker run -p 8088:8088 -d amancevice/superset
[root@bogon ~]# docker run -p 8088:8088 -d amancevice/superset
989c3f7b54397ba0e94cc69a73be95842c1c909a64e91439801f45396f88af3d
  • 查看Superset容器
[root@bogon ~]# docker ps
CONTAINER ID        IMAGE                 COMMAND                  CREATED             STATUS                   PORTS                    NAMES
989c3f7b5439        amancevice/superset   "gunicorn superset:a…"   3 minutes ago       Up 3 minutes (healthy)   0.0.0.0:8088->8088/tcp   recursing_nobel
  • 初始化Superset容器,注册账号信息,并等待初始化完成
[root@bogon ~]# docker exec -it 989c3f7b5439 superset-init
Username [admin]: admin
User first name [admin]: admin
User last name [user]: admin
Email [admin@fab.org]: admin
Password: 
Repeat for confirmation: 
/usr/local/lib/python3.6/site-packages/psycopg2/__init__.py:144: UserWarning: The psycopg2 wheel package will be renamed from release 2.8; in order to keep installing from binary please use "pip install psycopg2-binary" instead. For details see: <http://initd.org/psycopg/docs/install.html#binary-install-from-pypi>.
  """)
2020-03-03 08:13:49,694:INFO:root:logging was configured successfully
2020-03-03 08:13:49,819:INFO:root:Configured event logger of type <class 'superset.utils.log.DBEventLogger'>
2020-03-03 08:13:50,339:DEBUG:asyncio:Using selector: EpollSelector
Recognized Database Authentications.
Admin User admin created.
/usr/local/lib/python3.6/site-packages/psycopg2/__init__.py:144: UserWarning: The psycopg2 wheel package will be renamed from release 2.8; in order to keep installing from binary please use "pip install psycopg2-binary" instead. For details see: <http://initd.org/psycopg/docs/install.html#binary-install-from-pypi>.
  """)
2020-03-03 08:13:53,231:INFO:root:logging was configured successfully
2020-03-03 08:13:53,388:INFO:root:Configured event logger of type <class 'superset.utils.log.DBEventLogger'>
2020-03-03 08:13:53,828:DEBUG:asyncio:Using selector: EpollSelector
INFO  [alembic.runtime.migration] Context impl SQLiteImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> 4e6a06bad7a8, Init
INFO  [alembic.runtime.migration] Running upgrade 4e6a06bad7a8 -> 5a7bad26f2a7, empty message
INFO  [alembic.runtime.migration] Running upgrade 5a7bad26f2a7 -> 1e2841a4128, empty message
INFO  [alembic.runtime.migration] Running upgrade 1e2841a4128 -> 2929af7925ed, TZ offsets in data sources
INFO  [alembic.runtime.migration] Running upgrade 2929af7925ed -> 289ce07647b, Add encrypted password field
INFO  [alembic.runtime.migration] Running upgrade 289ce07647b -> 1a48a5411020, adding slug to dash
INFO  [alembic.runtime.migration] Running upgrade 1a48a5411020 -> 315b3f4da9b0, adding log model
INFO  [alembic.runtime.migration] Running upgrade 315b3f4da9b0 -> 55179c7f25c7, sqla_descr
INFO  [alembic.runtime.migration] Running upgrade 55179c7f25c7 -> 12d55656cbca, is_featured
/usr/local/lib/python3.6/site-packages/alembic/ddl/sqlite.py:39: UserWarning: Skipping unsupported ALTER for creation of implicit constraint
  "Skipping unsupported ALTER for "
INFO  [alembic.runtime.migration] Running upgrade 12d55656cbca -> 2591d77e9831, user_id
INFO  [alembic.runtime.migration] Running upgrade 2591d77e9831 -> 8e80a26a31db, empty message
INFO  [alembic.runtime.migration] Running upgrade 8e80a26a31db -> 7dbf98566af7, empty message
INFO  [alembic.runtime.migration] Running upgrade 7dbf98566af7 -> 43df8de3a5f4, empty message
INFO  [alembic.runtime.migration] Running upgrade 43df8de3a5f4 -> d827694c7555, css templates
INFO  [alembic.runtime.migration] Running upgrade d827694c7555 -> 430039611635, log more
INFO  [alembic.runtime.migration] Running upgrade 430039611635 -> 18e88e1cc004, making audit nullable
INFO  [alembic.runtime.migration] Running upgrade 18e88e1cc004 -> 836c0bf75904, cache_timeouts
INFO  [alembic.runtime.migration] Running upgrade 18e88e1cc004 -> a2d606a761d9, adding favstar model
INFO  [alembic.runtime.migration] Running upgrade a2d606a761d9, 836c0bf75904 -> d2424a248d63, empty message
INFO  [alembic.runtime.migration] Running upgrade d2424a248d63 -> 763d4b211ec9, fixing audit fk
INFO  [alembic.runtime.migration] Running upgrade d2424a248d63 -> 1d2ddd543133, log dt
INFO  [alembic.runtime.migration] Running upgrade 1d2ddd543133, 763d4b211ec9 -> fee7b758c130, empty message
INFO  [alembic.runtime.migration] Running upgrade fee7b758c130 -> 867bf4f117f9, Adding extra field to Database model
INFO  [alembic.runtime.migration] Running upgrade 867bf4f117f9 -> bb51420eaf83, add schema to table model
INFO  [alembic.runtime.migration] Running upgrade bb51420eaf83 -> b4456560d4f3, change_table_unique_constraint
INFO  [alembic.runtime.migration] Running upgrade b4456560d4f3 -> 4fa88fe24e94, owners_many_to_many
INFO  [alembic.runtime.migration] Running upgrade 4fa88fe24e94 -> c3a8f8611885, Materializing permission
INFO  [alembic.runtime.migration] Running upgrade c3a8f8611885 -> f0fbf6129e13, Adding verbose_name to tablecolumn
INFO  [alembic.runtime.migration] Running upgrade f0fbf6129e13 -> 956a063c52b3, adjusting key length
INFO  [alembic.runtime.migration] Running upgrade 956a063c52b3 -> 1226819ee0e3, Fix wrong constraint on table columns
INFO  [alembic.runtime.migration] Running upgrade 1226819ee0e3 -> d8bc074f7aad, Add new field 'is_restricted' to SqlMetric and DruidMetric
INFO  [alembic.runtime.migration] Running upgrade d8bc074f7aad -> 27ae655e4247, Make creator owners
INFO  [alembic.runtime.migration] Running upgrade 27ae655e4247 -> 960c69cb1f5b, add dttm_format related fields in table_columns
INFO  [alembic.runtime.migration] Running upgrade 960c69cb1f5b -> f162a1dea4c4, d3format_by_metric
INFO  [alembic.runtime.migration] Running upgrade f162a1dea4c4 -> ad82a75afd82, Update models to support storing the queries.
INFO  [alembic.runtime.migration] Running upgrade ad82a75afd82 -> 3c3ffe173e4f, add_sql_string_to_table
INFO  [alembic.runtime.migration] Running upgrade 3c3ffe173e4f -> 41f6a59a61f2, database options for sql lab
INFO  [alembic.runtime.migration] Running upgrade 41f6a59a61f2 -> 4500485bde7d, allow_run_sync_async
INFO  [alembic.runtime.migration] Running upgrade 4500485bde7d -> 65903709c321, allow_dml
INFO  [alembic.runtime.migration] Running upgrade 41f6a59a61f2 -> 33d996bcc382, update slice model
INFO  [alembic.runtime.migration] Running upgrade 33d996bcc382, 65903709c321 -> b347b202819b, empty message
INFO  [alembic.runtime.migration] Running upgrade b347b202819b -> 5e4a03ef0bf0, Add access_request table to manage requests to access datastores.
INFO  [alembic.runtime.migration] Running upgrade 5e4a03ef0bf0 -> eca4694defa7, sqllab_setting_defaults
INFO  [alembic.runtime.migration] Running upgrade eca4694defa7 -> ab3d66c4246e, add_cache_timeout_to_druid_cluster
INFO  [alembic.runtime.migration] Running upgrade eca4694defa7 -> 3b626e2a6783, Sync DB with the models.py.
WARNI [root] Constraint must have a name
INFO  [alembic.runtime.migration] Running upgrade 3b626e2a6783, ab3d66c4246e -> ef8843b41dac, empty message
INFO  [alembic.runtime.migration] Running upgrade ef8843b41dac -> b46fa1b0b39e, Add json_metadata to the tables table.
INFO  [alembic.runtime.migration] Running upgrade b46fa1b0b39e -> 7e3ddad2a00b, results_key to query
INFO  [alembic.runtime.migration] Running upgrade 7e3ddad2a00b -> ad4d656d92bc, Add avg() to default metrics
INFO  [alembic.runtime.migration] Running upgrade ad4d656d92bc -> c611f2b591b8, dim_spec
INFO  [alembic.runtime.migration] Running upgrade c611f2b591b8 -> e46f2d27a08e, materialize perms
INFO  [alembic.runtime.migration] Running upgrade e46f2d27a08e -> f1f2d4af5b90, Enable Filter Select
INFO  [alembic.runtime.migration] Running upgrade e46f2d27a08e -> 525c854f0005, log_this_plus
INFO  [alembic.runtime.migration] Running upgrade 525c854f0005, f1f2d4af5b90 -> 6414e83d82b7, empty message
INFO  [alembic.runtime.migration] Running upgrade 6414e83d82b7 -> 1296d28ec131, Adds params to the datasource (druid) table
INFO  [alembic.runtime.migration] Running upgrade 1296d28ec131 -> f18570e03440, Add index on the result key to the query table.
INFO  [alembic.runtime.migration] Running upgrade f18570e03440 -> bcf3126872fc, Add keyvalue table
INFO  [alembic.runtime.migration] Running upgrade f18570e03440 -> db0c65b146bd, update_slice_model_json
INFO  [alembic.runtime.migration] Running upgrade db0c65b146bd -> a99f2f7c195a, rewriting url from shortner with new format
INFO  [alembic.runtime.migration] Running upgrade a99f2f7c195a, bcf3126872fc -> d6db5a5cdb5d, empty message
INFO  [alembic.runtime.migration] Running upgrade d6db5a5cdb5d -> b318dfe5fb6c, adding verbose_name to druid column
INFO  [alembic.runtime.migration] Running upgrade d6db5a5cdb5d -> 732f1c06bcbf, add fetch values predicate
INFO  [alembic.runtime.migration] Running upgrade 732f1c06bcbf, b318dfe5fb6c -> ea033256294a, empty message
INFO  [alembic.runtime.migration] Running upgrade b318dfe5fb6c -> db527d8c4c78, Add verbose name to DruidCluster and Database
INFO  [alembic.runtime.migration] Running upgrade db527d8c4c78, ea033256294a -> 979c03af3341, empty message
INFO  [alembic.runtime.migration] Running upgrade 979c03af3341 -> a6c18f869a4e, query.start_running_time
INFO  [alembic.runtime.migration] Running upgrade a6c18f869a4e -> 2fcdcb35e487, saved_queries
INFO  [alembic.runtime.migration] Running upgrade 2fcdcb35e487 -> a65458420354, add_result_backend_time_logging
INFO  [alembic.runtime.migration] Running upgrade a65458420354 -> ca69c70ec99b, tracking_url
INFO  [alembic.runtime.migration] Running upgrade ca69c70ec99b -> a9c47e2c1547, add impersonate_user to dbs
INFO  [alembic.runtime.migration] Running upgrade ca69c70ec99b -> ddd6ebdd853b, annotations
INFO  [alembic.runtime.migration] Running upgrade a9c47e2c1547, ddd6ebdd853b -> d39b1e37131d, empty message
INFO  [alembic.runtime.migration] Running upgrade ca69c70ec99b -> 19a814813610, Adding metric warning_text
INFO  [alembic.runtime.migration] Running upgrade 19a814813610, a9c47e2c1547 -> 472d2f73dfd4, empty message
INFO  [alembic.runtime.migration] Running upgrade 472d2f73dfd4, d39b1e37131d -> f959a6652acd, empty message
INFO  [alembic.runtime.migration] Running upgrade f959a6652acd -> 4736ec66ce19, empty message
/usr/local/lib/python3.6/site-packages/sqlalchemy/dialects/sqlite/base.py:1842: SAWarning: WARNING: SQL-parsed foreign key constraint '('datasource_name', 'datasources', 'datasource_name')' could not be located in PRAGMA foreign_keys for table metrics
  "foreign_keys for table %s" % (sig, table_name)
INFO  [alembic.runtime.migration] Running upgrade 4736ec66ce19 -> 67a6ac9b727b, update_spatial_params
INFO  [alembic.runtime.migration] Running upgrade 67a6ac9b727b -> 21e88bc06c02
INFO  [alembic.runtime.migration] Running upgrade 21e88bc06c02 -> e866bd2d4976, smaller_grid
Revision ID: e866bd2d4976
Revises: 21e88bc06c02
Create Date: 2018-02-13 08:07:40.766277
INFO  [alembic.runtime.migration] Running upgrade e866bd2d4976 -> e68c4473c581, allow_multi_schema_metadata_fetch
INFO  [alembic.runtime.migration] Running upgrade e68c4473c581 -> f231d82b9b26, empty message
INFO  [alembic.runtime.migration] Running upgrade f231d82b9b26 -> bf706ae5eb46, cal_heatmap_metric_to_metrics
INFO  [alembic.runtime.migration] Running upgrade f231d82b9b26 -> 30bb17c0dc76, empty message
INFO  [alembic.runtime.migration] Running upgrade 30bb17c0dc76, bf706ae5eb46 -> c9495751e314, empty message
INFO  [alembic.runtime.migration] Running upgrade f231d82b9b26 -> 130915240929, is_sqllab_view
INFO  [alembic.runtime.migration] Running upgrade 130915240929, c9495751e314 -> 5ccf602336a0, empty message
INFO  [alembic.runtime.migration] Running upgrade 5ccf602336a0 -> e502db2af7be, add template_params to tables
INFO  [alembic.runtime.migration] Running upgrade e502db2af7be -> c5756bec8b47, Time grain SQLA
INFO  [alembic.runtime.migration] Running upgrade c5756bec8b47 -> afb7730f6a9c, remove empty filters
INFO  [alembic.runtime.migration] Running upgrade afb7730f6a9c -> 80a67c5192fa, single pie chart metric
INFO  [alembic.runtime.migration] Running upgrade 80a67c5192fa -> bddc498dd179, adhoc filters
INFO  [alembic.runtime.migration] Running upgrade bddc498dd179 -> 3dda56f1c4c6, Migrate num_period_compare and period_ratio_type
INFO  [alembic.runtime.migration] Running upgrade 3dda56f1c4c6 -> 1d9e835a84f9, empty message
INFO  [alembic.runtime.migration] Running upgrade bddc498dd179 -> 4451805bbaa1, remove double percents
INFO  [alembic.runtime.migration] Running upgrade 4451805bbaa1, 1d9e835a84f9 -> 705732c70154, empty message
INFO  [alembic.runtime.migration] Running upgrade 4451805bbaa1, 1d9e835a84f9 -> fc480c87706c, empty message
INFO  [alembic.runtime.migration] Running upgrade fc480c87706c -> bebcf3fed1fe, Migrate dashboard position_json data from V1 to V2
INFO  [alembic.runtime.migration] Running upgrade bebcf3fed1fe, 705732c70154 -> ec1f88a35cc6, empty message
INFO  [alembic.runtime.migration] Running upgrade 4451805bbaa1, 1d9e835a84f9 -> e3970889f38e, empty message
INFO  [alembic.runtime.migration] Running upgrade 705732c70154, e3970889f38e -> 46ba6aaaac97, empty message
INFO  [alembic.runtime.migration] Running upgrade 46ba6aaaac97, ec1f88a35cc6 -> c18bd4186f15, empty message
INFO  [alembic.runtime.migration] Running upgrade c18bd4186f15 -> 7fcdcde0761c, Reduce position_json size by remove extra space and component id prefix
INFO  [alembic.runtime.migration] Running upgrade 7fcdcde0761c -> 0c5070e96b57, add user attributes table
INFO  [alembic.runtime.migration] Running upgrade 0c5070e96b57 -> 1a1d627ebd8e, position_json
INFO  [alembic.runtime.migration] Running upgrade 1a1d627ebd8e -> 55e910a74826, add_metadata_column_to_annotation_model.py
INFO  [alembic.runtime.migration] Running upgrade 55e910a74826 -> 4ce8df208545, empty message
INFO  [alembic.runtime.migration] Running upgrade 4ce8df208545 -> 46f444d8b9b7, remove_coordinator_from_druid_cluster_model.py
INFO  [alembic.runtime.migration] Running upgrade 46f444d8b9b7 -> a61b40f9f57f, remove allow_run_sync
INFO  [alembic.runtime.migration] Running upgrade a61b40f9f57f -> 6c7537a6004a, models for email reports
INFO  [alembic.runtime.migration] Running upgrade 6c7537a6004a -> 3e1b21cd94a4, change_owner_to_m2m_relation_on_datasources.py
INFO  [alembic.runtime.migration] Running upgrade 6c7537a6004a -> cefabc8f7d38, Increase size of name column in ab_view_menu
INFO  [alembic.runtime.migration] Running upgrade 55e910a74826 -> 0b1f1ab473c0, Add extra column to Query
INFO  [alembic.runtime.migration] Running upgrade 0b1f1ab473c0, cefabc8f7d38, 3e1b21cd94a4 -> de021a1ca60d, empty message
INFO  [alembic.runtime.migration] Running upgrade de021a1ca60d -> fb13d49b72f9, better_filters
INFO  [alembic.runtime.migration] Running upgrade fb13d49b72f9 -> a33a03f16c4a, Add extra column to SavedQuery
INFO  [alembic.runtime.migration] Running upgrade 4451805bbaa1, 1d9e835a84f9 -> c829ff0b37d0, empty message
INFO  [alembic.runtime.migration] Running upgrade c829ff0b37d0 -> 7467e77870e4, remove_aggs
INFO  [alembic.runtime.migration] Running upgrade 7467e77870e4, de021a1ca60d -> fbd55e0f83eb, empty message
INFO  [alembic.runtime.migration] Running upgrade fbd55e0f83eb, fb13d49b72f9 -> 8b70aa3d0f87, empty message
INFO  [alembic.runtime.migration] Running upgrade 8b70aa3d0f87, a33a03f16c4a -> 18dc26817ad2, empty message
INFO  [alembic.runtime.migration] Running upgrade 18dc26817ad2 -> c617da68de7d, form nullable
INFO  [alembic.runtime.migration] Running upgrade c617da68de7d -> c82ee8a39623, Add implicit tags
INFO  [alembic.runtime.migration] Running upgrade 18dc26817ad2 -> e553e78e90c5, add_druid_auth_py.py
INFO  [alembic.runtime.migration] Running upgrade e553e78e90c5, c82ee8a39623 -> 45e7da7cfeba, empty message
INFO  [alembic.runtime.migration] Running upgrade 45e7da7cfeba -> 80aa3f04bc82, Add Parent ids in dashboard layout metadata
INFO  [alembic.runtime.migration] Running upgrade 80aa3f04bc82 -> d94d33dbe938, form strip
INFO  [alembic.runtime.migration] Running upgrade d94d33dbe938 -> 937d04c16b64, update datasources
INFO  [alembic.runtime.migration] Running upgrade 937d04c16b64 -> 7f2635b51f5d, update base columns
INFO  [alembic.runtime.migration] Running upgrade 7f2635b51f5d -> e9df189e5c7e, update base metrics
INFO  [alembic.runtime.migration] Running upgrade e9df189e5c7e -> afc69274c25a, update the sql, select_sql, and executed_sql columns in the
   query table in mysql dbs to be long text columns
INFO  [alembic.runtime.migration] Running upgrade afc69274c25a -> d7c1a0d6f2da, Remove limit used from query model
INFO  [alembic.runtime.migration] Running upgrade d7c1a0d6f2da -> ab8c66efdd01, resample
INFO  [alembic.runtime.migration] Running upgrade ab8c66efdd01 -> b4a38aa87893, deprecate database expression
INFO  [alembic.runtime.migration] Running upgrade b4a38aa87893 -> d6ffdf31bdd4, Add published column to dashboards
INFO  [alembic.runtime.migration] Running upgrade d6ffdf31bdd4 -> 190188938582, Remove duplicated entries in dashboard_slices table and add unique constraint
INFO  [alembic.runtime.migration] Running upgrade 190188938582 -> def97f26fdfb, Add index to tagged_object
INFO  [alembic.runtime.migration] Running upgrade def97f26fdfb -> 11c737c17cc6, deprecate_restricted_metrics
INFO  [alembic.runtime.migration] Running upgrade 11c737c17cc6 -> 258b5280a45e, form strip leading and trailing whitespace
INFO  [alembic.runtime.migration] Running upgrade 258b5280a45e -> 1495eb914ad3, time range
INFO  [alembic.runtime.migration] Running upgrade 1495eb914ad3 -> b6fa807eac07, make_names_non_nullable
/usr/local/lib/python3.6/site-packages/psycopg2/__init__.py:144: UserWarning: The psycopg2 wheel package will be renamed from release 2.8; in order to keep installing from binary please use "pip install psycopg2-binary" instead. For details see: <http://initd.org/psycopg/docs/install.html#binary-install-from-pypi>.
  """)
2020-03-03 08:13:59,403:INFO:root:logging was configured successfully
2020-03-03 08:13:59,557:INFO:root:Configured event logger of type <class 'superset.utils.log.DBEventLogger'>
2020-03-03 08:14:00,217:DEBUG:asyncio:Using selector: EpollSelector
2020-03-03 08:14:01,699:INFO:root:Creating database reference for examples
2020-03-03 08:14:09,064:INFO:root:Syncing role definition
2020-03-03 08:14:09,117:INFO:root:Syncing Admin perms
2020-03-03 08:14:09,232:INFO:root:Syncing Alpha perms
2020-03-03 08:14:09,670:INFO:root:Syncing Gamma perms
2020-03-03 08:14:10,090:INFO:root:Syncing granter perms
2020-03-03 08:14:10,413:INFO:root:Syncing sql_lab perms
2020-03-03 08:14:10,792:INFO:root:Fetching a set of all perms to lookup which ones are missing
2020-03-03 08:14:10,874:INFO:root:Creating missing datasource permissions.
2020-03-03 08:14:10,883:INFO:root:Creating missing database permissions.
2020-03-03 08:14:10,904:INFO:root:Creating missing metrics permissions
2020-03-03 08:14:10,909:INFO:root:Cleaning faulty perms
  • 登录 http://xxx.xxx.xxx.xxx:8088 并使用账号密码登录
    在这里插入图片描述

配置Mysql数据源

  • 进入Source菜单下的Databases
    在这里插入图片描述
  • 点击右上+号
    在这里插入图片描述
  • 填写链接信息
    Database 填写superset中保存的库名
    SQLAlchemy URI 格式 mysql+mysqldb://username:password@ip:port/database
    在这里插入图片描述
  • 进入Source菜单下的Tables并创建,选择数据库和表
    在这里插入图片描述
    在这里插入图片描述
  • 进入Charts菜单,选择上步创建的datasource和Table样式(我这里选择的是Bar Chart)
    在这里插入图片描述
    在这里插入图片描述
  • 根据需求填写左侧,并点击左上角 Run Query测试,配置完整后点击保存,填写Chart名称和看板,点击Save & go to dashboard 保存并查看
    在这里插入图片描述
    在这里插入图片描述
    在这里插入图片描述
渣蛙攻城狮
关注
  • 0
    点赞
  • 踩
  • 3
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
docker-superset:Apache Superset的高山容器
05-18
用于Apache Superset的Docker容器 基于高山容器的容器 预先安装了PostgreSQL和Redis后端 例子 以分离模式运行容器，并遵循： # Run container in detached mode and share its port docker run -p 127.0.0.1:8088:8088 --rm --detach --name superset_container terminal1/superset # Create an admin and migrate the database docker exec -it superset_container fabmanager create-admin --app superset docker exec -it superset_container superset db upgrade d
可视化报表Superset
最新发布
Shawn的个人博客
04-15 739
Apache Superset是一个现代的数据探索和可视化平台。它功能强大且十分易用，可对接各种数据源，包括很多现代的大数据分析引擎，拥有丰富的图表展示形式，并且支持自定义仪表盘。
bi superset搭建教程
山间明月江上清风的专栏
05-08 2443
superset是一个自助数据分析系统，支持大部分数据库，提供多种美观的图表，并可以在页面上配置纬度指标等来展示数据。 下面我们来搭建下这个系统，并连接mysql数据库展示数据。 采用docker搭建，方面在不同系统安装。 运行superset镜像 docker run -d -p 8088:8088 -v supersetData:/var/lib/superset --name sup...
Docker部署apache superset
卖辣椒也用券
05-19 2845
这里我选择手动下载rpm包，然后yum install *.rpm方式来安装。下载地址：https://download.docker.com/linux/centos/7/x86_64/stable/Packages/说明：因为我是Centos7.9的系统，所以下载地址如上。若你是其他系统，请选择自己对应的系统-可参考这个网页https://docs.docker.com/engine/install/。
使用docker部署apache superset
slxz001的博客
02-21 1071
使用docker部署apache superset
基于Docker快速搭建ELK的方法
09-29
主要介绍了基于Docker快速搭建ELK的方法，文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值，需要的朋友们下面随着小编来一起学习学习吧
Docker快速搭建Redis集群的方法示例
09-08
主要介绍了Docker快速搭建Redis集群的方法示例,文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值，需要的朋友们下面随着小编来一起学习学习吧
一文教你如何通过 Docker 快速搭建各种测试环境
09-29
主要介绍了一文教你如何通过 Docker 快速搭建各种测试环境，文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值，需要的朋友们下面随着小编来一起学习学习吧
docker-superset：AirBnB的Superset的Docker映像
02-05
docker-superset：AirBnB的Superset的Docker映像
安装Apache Superset--基于Docker的安装配置
nikeylee的博客
03-27 6046
下载Superset镜像 查找星最多的镜像：docker search superset 下载镜像（选择STARS最高的amancevice/superset）：docker pull amancevice/superset 查看镜像是否下载成功：docker images 安装Superset 初始化Superset ...
使用Docker部署Apache Superset并实现公网远程访问
asdssadddd的博客
10-26 1704
Superset是一款由中国知名科技公司开源的“现代化的企业级BI（商业智能）Web应用程序”，其通过创建和分享dashboard，为数据分析提供了轻量级的数据查询和可视化方案。Superset在数据处理和可视化方面具有强大的功能，能够满足企业级的数据分析需求，并为用户提供直观、灵活的数据探索和展示方式。通过Superset，用户可以轻松地从海量数据中提取有价值的信息，帮助企业做出更加明智的决策。另外，团队协作进行数据分析，可以结合国内流行的内网穿透工具实现公网的实时远程访问数据。
基于docker安装superset
热门推荐
举头三尺有神明
02-21 1万+
安装前准备 安装docker 检查是否已安装docker（docker version） root@VM-32-248-ubuntu:~# docker version Client: Version: 1.13.1 API version: 1.26 Go version: go1.6.2 Git commit: 092cba3 Built: ...
快速部署 k8s 集群（kubeadm）
super_song的博客
06-09 364
1. 安装须知 部署k8s集群机器需要满足以下条件： 多台机器或一台机器多个虚拟机，操作系统 CentOS7.x-86_x64 硬件要求：RAM：2GB+，CPU双核+，硬盘30GB+ 可以连外网，拉取镜像，否则需要提前准备镜像导入节点 禁止swap分区 2. 虚拟机初始化设置 节点 IP地址 master1 192.168.126.140 node1 192.168.126.141 node2 192.168.126.142 # 关闭防火墙 systemctl stop f
superset数据分析平台搭建(docker)
qq_40104240的博客
10-15 759
superset数据分析平台搭建使用Docker Compose在本地安装Superset1.安装Docker引擎和Docker Compose2.克隆Superset的GitHub仓库3.使用Docker Compose启动Superset4.登录Superset5.docker镜像网络转发配置6.再次登录访问7.恭喜 使用Docker Compose在本地安装Superset 使用Docker和Docker Compose，是在linux或Mac OSX电脑上，最快本地化使用Superset的方式。Su
superset安装和部署(超详细)
m0_74756715的博客
11-21 4651
Apache Superset是一个开源的、现代的、轻量级BI分析工具，能够对接多种数据源、拥有丰富的图表展示形式、支持自定义仪表盘，且拥有友好的用户界面，十分易用。
部署一套完整的Kubernetes高可用集群（下）
Richardlygo的博客
06-12 166
七、高可用架构（扩容多Master架构） Kubernetes作为容器集群系统，通过健康检查+重启策略实现了Pod故障自我修复能力，通过调度算法实现将Pod分布式部署，并保持预期副本数，根据Node失效状态自动在其他Node拉起Pod，实现了应用层的高可用性。 针对Kubernetes集群，高可用性还应包含以下两个层面的考虑：Etcd数据库的高可用性和Kubernetes Master组件的高可用性。而Etcd我们已经采用3个节点组建集群实现高可用，本节将对Master节点高可用进行说明和实施。 Ma
SuperSet安装与使用
lbship的博客
05-26 1288
一、安装 1.安装docker 如果没有安装docker可以看这里K8S原理、安装和部署 2.安装dockers-compose sudo curl -L "https://github.com/docker/compose/releases/download/1.29.2/docker-compose-$(uname -s)-$(uname -m)" -o /usr/local/bin/docker-compose sudo chmod +x /usr/local/bin/docker-comp
docker环境下的superset升级
qq_38360409的博客
05-13 924
1.拉取最新镜像，这里选择的是apache/superset:master docker pull apache/superset:master 2.使用镜像启动对应的新服务(注意：name和本地映射目录不要和之前的superset重复) docker run -d -p 8088:8088 -v /opt/docker/superset:/home/superset --name superset amancevice/superset docker cp /etc/localtime 13fb148b
docker快速搭建开发环境
10-13
要快速搭建开发环境，可以使用 Docker。Docker 是一个开源的应用容器引擎，可以让开发者打包自己的应用及其依赖，并且可以在任何地方运行。以下是快速搭建开发环境的步骤： 1. 安装 Docker：在官网下载并安装 ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值