superset（一）详细部署步骤(python 3.7.15、windows11)及验证异常处理

已于 2024-08-13 08:57:38 修改
阅读量4.7w 收藏 2
点赞数 3
分类专栏： 大数据相关组件介绍 文章标签： python superset 数据可视化 数据分析 大数据展示 superset python 大数据
于 2023-07-03 15:41:44 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/chenwewi520feng/article/details/131516262
版权

Superset 系列文章

superset（一）详细部署步骤(python 3.7.15、windows11)及验证异常处理
superset（二）基本使用详细示例以及superset权限控制介绍

文章目录

本文简单的介绍了superset的功能、应用场景以及部署和验证。
本文部分图片来源于网络。
本文分为2个部分，即superset介绍、部署及验证的详细步骤。

一、简介

1、介绍

superset github地址：https://github.com/apache/superset
官方文档：http://superset.apache.org/installation.html

Superset 是 Airbnb开源的数据探查与可视化平台，是个轻量级的BI工具，是一款开源的现代化企业级BI。
它是目前开源的数据分析和可视化工具中比较好用的，功能简单但可以满足对数据的一般需求，支持多种数据源，图表类型多，易维护，易进行二次开发。

Superset 的前端主要用到了 React 和 NVD3/D3，而后端则基于 Python 的 Flask 框架和 Pandas、SQLAlchemy 等依赖库，主要提供了这几方面的功能：

  • 集成数据查询功能，支持多种数据库，包括 MySQL、PostgresSQL、Oracle、SQL Server、SQLite、SparkSQL 等，并深度支持 Druid
  • 通过 NVD3/D3 预定义了多种可视化图表，满足大部分的数据展示功能。如果还有其他需求，也可以自开发更多的图表类型，或者嵌入其他的 JavaScript 图表库（如 HighCharts、ECharts）
  • 提供细粒度安全模型，可以在功能层面和数据层面进行访问控制。支持多种鉴权方式（如数据库、OpenID、LDAP、OAuth、REMOTE_USER 等）

2、功能

  • 丰富的数据可视化集
  • 易于使用的界面，用于浏览和可视化数据
  • 创建和共享仪表板
  • 与主要身份验证提供程序（数据库，OpenID，LDAP，OAuth和REMOTE_USER通过Flask AppBuilder集成）集成的企业就绪身份验证
  • 可扩展的高粒度安全性/权限模型，允许有关谁可以访问单个要素和数据集的复杂规则
  • 一个简单的语义层，允许用户通过定义哪些字段应显示在哪些下拉列表中以及哪些聚合和功能度量可供用户使用来控制如何在UI中显示数据源
  • 通过SQLAlchemy与大多数说SQL的RDBMS集成
  • 与Druid.io的深度集成

二、部署及验证

1、构建虚拟环境

不构建虚拟环境也是可以搭建的，这里构建虚拟环境可以相对保证只需要用到Superset的依赖库，纯净。

这里简单介绍构建虚拟环境的方式，其中一种是通过Anconada navigator直接创建，另外一种是在命令行通过命令创建，大家可以根据自己的实际情况进行选择尝试。

1）、Anconada navigator构建

安装Anconada后，可以直接打开 Anconada navigator，通过以下示例图方式创建虚拟环境superset_demo （名字可以自定义）
软件安装、下载链接：https://anaconda.org.cn/anaconda/navigator/install/
在这里插入图片描述
先点击create，然后填写一个名称和选择一个python的版本（该步骤非常重要，本示例选择其他的版本3.9版本没有成功）、更新superset需要的其他类库。

2）、命令行

安装Anconada后，通过以下命令即可创建一个名为“superset_demo”的虚拟环境。

conda create -n supersetTest python=3.7.15

图文不一致，示意如下：
在这里插入图片描述
如果是直接安装的python官方环境，可以先安装一个用于创建虚拟环境的第三方库virtualenv，然后再进行虚拟环境构建。

# 安装第三方库
pip install virtualenv
# 创建一个名为superset_demo且不拷贝系统的python第三方库的虚拟环境
virtualenv --no-site-packages superset_demo
# 激活该虚拟环境
superset_demo\Scripts\activate.bat
# 退出该虚拟环境
superset_demo\Scripts\deactivate.bat

2、激活虚拟环境

通过上述方式一，构建了虚拟环境 superset_demo，由于安装superset关联的第三方库较多，激活该虚拟环境后再进行superset的安装。

# 激活虚拟环境，后续在该环境下安装相关库
activate superset_demo

在这里插入图片描述
在该命令行中输入 “activate superset_demo”命令即可

3、安装superset

在之前就行安装的时候，遇到很多问题，当然最后都解决了，所以这里直接以最终解决后总结的安装步骤进行介绍（注意：需要安装在上一步构建的虚拟环境中）。

1）、升级setuptools和pip

# Put all the chances on your side by getting the very latest pip and setuptools libraries.:
pip install --upgrade setuptools pip

2）、本地安装以下两个库

python_geohash-0.8.5-cp37-cp37m-win_amd64.whl
sasl-0.3.1-cp37-cp37m-win_amd64.whl

到https://www.lfd.uci.edu/~gohlke/pythonlibs进行以上两个轮子的下载（大家根据自己的环境进行版本选择），然后本地安装（路径无所谓，就是下载文件所在的位置），安装过程中一定要注意 被安装文件路径写全。

pip install C:\virtualenv_env\python_geohash-0.8.5-cp37-cp37m-win_amd64.whl
pip install C:\virtualenv_env\sasl-0.3.1-cp37-cp37m-win_amd64.whl

在这里插入图片描述

3）、安装superset

完成第一步的安装后，再进行本步骤，一般是很可以很顺利完成安装的，否则可能会出现很多报错（基本都是依赖关系库版本匹配问题等）

pip install apache-superset==0.36.0

4）、初始化superset

直接拷贝官网初始化流程如下（该步骤会存在各种版本不一致的情况，按照错误提示逐个解决即可）：

# Initialize the database
superset db upgrade

# Create an admin user (you will be prompted to set a username, first and last name before setting a password)
$ export FLASK_APP=superset
superset fab create-admin

# Load some data to play with
superset load_examples

# Create default roles and permissions
superset init

# To start a development web server on port 8088, use -p to bind to another port
superset run -p 8088 --with-threads --reload --debugger

不过，这些命令需要在superset安装路径下使用，比如我的环境是这样：

C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\bin

每一步之前记得加上 python，比如python superset db upgrade

(superset_demo) C:\Users\chenw>cd C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\bin

(superset_demo) C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\bin>python superset db upgrade
Traceback (most recent call last):
  File "superset", line 18, in <module>
    from superset.cli import superset
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\superset\__init__.py", line 21, in <module>
    from superset.app import create_app
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\superset\app.py", line 29, in <module>
    from superset.extensions import (
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\superset\extensions.py", line 118, in <module>
    celery_app = celery.Celery()
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\celery\local.py", line 509, in __getattr__
    module = __import__(self._object_origins[name], None, None, [name])
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\celery\app\__init__.py", line 5, in <module>
    from celery import _state
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\celery\_state.py", line 17, in <module>
    from celery.utils.threads import LocalStack
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\celery\utils\__init__.py", line 19, in <module>
    from .nodenames import nodename, nodesplit, worker_direct
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\celery\utils\nodenames.py", line 9, in <module>
    from kombu.entity import Exchange, Queue
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\kombu\entity.py", line 9, in <module>
    from .serialization import prepare_accept_content
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\kombu\serialization.py", line 456, in <module>
    for ep, args in entrypoints('kombu.serializers'):  # pragma: no cover
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\kombu\utils\compat.py", line 93, in entrypoints
    for ep in importlib_metadata.entry_points().get(namespace, [])
AttributeError: 'EntryPoints' object has no attribute 'get'

(superset_demo) C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\bin>pip install requests
Collecting requests
  Using cached requests-2.28.1-py3-none-any.whl (62 kB)
Requirement already satisfied: idna<4,>=2.5 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from requests) (3.4)
Requirement already satisfied: urllib3<1.27,>=1.21.1 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from requests) (1.26.13)
Collecting charset-normalizer<3,>=2
  Using cached charset_normalizer-2.1.1-py3-none-any.whl (39 kB)
Requirement already satisfied: certifi>=2017.4.17 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from requests) (2022.12.7)
Installing collected packages: charset-normalizer, requests
Successfully installed charset-normalizer-2.1.1 requests-2.28.1

(superset_demo) C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\bin>pip install flask-appbuilder
Requirement already satisfied: flask-appbuilder in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (2.3.4)
Requirement already satisfied: email-validator<2,>=1.0.5 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask-appbuilder) (1.3.0)
Requirement already satisfied: marshmallow-enum<2,>=1.4.1 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask-appbuilder) (1.5.1)
Requirement already satisfied: Flask-SQLAlchemy<3,>=2.4 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask-appbuilder) (2.5.1)
Requirement already satisfied: jsonschema<4,>=3.0.1 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask-appbuilder) (3.2.0)
Requirement already satisfied: Flask-Babel<2,>=1 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask-appbuilder) (1.0.0)
Requirement already satisfied: colorama<1,>=0.3.9 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask-appbuilder) (0.4.6)
Requirement already satisfied: marshmallow<3.0.0,>=2.18.0 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask-appbuilder) (2.21.0)
Requirement already satisfied: Flask-JWT-Extended<4,>=3.18 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask-appbuilder) (3.25.1)
Requirement already satisfied: prison<1.0.0,>=0.1.3 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask-appbuilder) (0.2.1)
Requirement already satisfied: marshmallow-sqlalchemy<1,>=0.16.1 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask-appbuilder) (0.23.1)
Requirement already satisfied: PyJWT>=1.7.1 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask-appbuilder) (1.7.1)
Requirement already satisfied: python-dateutil<3,>=2.3 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask-appbuilder) (2.8.2)
Requirement already satisfied: click<8,>=6.7 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask-appbuilder) (7.1.2)
Requirement already satisfied: Flask-Login<0.5,>=0.3 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask-appbuilder) (0.4.1)
Requirement already satisfied: apispec[yaml]<2,>=1.1.1 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask-appbuilder) (1.3.3)
Requirement already satisfied: sqlalchemy-utils<1,>=0.32.21 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask-appbuilder) (0.39.0)
Requirement already satisfied: Flask-WTF<1,>=0.14.2 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask-appbuilder) (0.15.1)
Requirement already satisfied: Flask-OpenID<2,>=1.2.5 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask-appbuilder) (1.3.0)
Requirement already satisfied: Flask<2,>=0.12 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask-appbuilder) (1.1.4)
Requirement already satisfied: PyYAML>=3.10 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from apispec[yaml]<2,>=1.1.1->flask-appbuilder) (6.0)
Requirement already satisfied: dnspython>=1.15.0 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from email-validator<2,>=1.0.5->flask-appbuilder) (2.2.1)
Requirement already satisfied: idna>=2.0.0 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from email-validator<2,>=1.0.5->flask-appbuilder) (3.4)
Requirement already satisfied: Werkzeug<2.0,>=0.15 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from Flask<2,>=0.12->flask-appbuilder) (1.0.1)
Requirement already satisfied: Jinja2<3.0,>=2.10.1 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from Flask<2,>=0.12->flask-appbuilder) (2.11.3)
Requirement already satisfied: itsdangerous<2.0,>=0.24 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from Flask<2,>=0.12->flask-appbuilder) (1.1.0)
Requirement already satisfied: pytz in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from Flask-Babel<2,>=1->flask-appbuilder) (2022.7)
Requirement already satisfied: Babel>=2.3 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from Flask-Babel<2,>=1->flask-appbuilder) (2.11.0)
Requirement already satisfied: six in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from Flask-JWT-Extended<4,>=3.18->flask-appbuilder) (1.16.0)
Requirement already satisfied: python3-openid>=2.0 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from Flask-OpenID<2,>=1.2.5->flask-appbuilder) (3.2.0)
Requirement already satisfied: SQLAlchemy>=0.8.0 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from Flask-SQLAlchemy<3,>=2.4->flask-appbuilder) (1.4.45)
Requirement already satisfied: WTForms in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from Flask-WTF<1,>=0.14.2->flask-appbuilder) (2.3.3)
Requirement already satisfied: attrs>=17.4.0 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from jsonschema<4,>=3.0.1->flask-appbuilder) (22.2.0)
Requirement already satisfied: setuptools in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from jsonschema<4,>=3.0.1->flask-appbuilder) (65.6.3)
Requirement already satisfied: importlib-metadata in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from jsonschema<4,>=3.0.1->flask-appbuilder) (5.2.0)
Requirement already satisfied: pyrsistent>=0.14.0 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from jsonschema<4,>=3.0.1->flask-appbuilder) (0.19.2)
Requirement already satisfied: MarkupSafe>=0.23 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from Jinja2<3.0,>=2.10.1->Flask<2,>=0.12->flask-appbuilder) (2.0.1)
Requirement already satisfied: defusedxml in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from python3-openid>=2.0->Flask-OpenID<2,>=1.2.5->flask-appbuilder) (0.7.1)
Requirement already satisfied: greenlet!=0.4.17 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from SQLAlchemy>=0.8.0->Flask-SQLAlchemy<3,>=2.4->flask-appbuilder) (2.0.1)
Requirement already satisfied: typing-extensions>=3.6.4 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from importlib-metadata->jsonschema<4,>=3.0.1->flask-appbuilder) (4.4.0)
Requirement already satisfied: zipp>=0.5 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from importlib-metadata->jsonschema<4,>=3.0.1->flask-appbuilder) (3.11.0)

(superset_demo) C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\bin>pip install werkzeug==0.16.1
Collecting werkzeug==0.16.1
  Using cached Werkzeug-0.16.1-py2.py3-none-any.whl (327 kB)
Installing collected packages: werkzeug
  Attempting uninstall: werkzeug
    Found existing installation: Werkzeug 1.0.1
    Uninstalling Werkzeug-1.0.1:
      Successfully uninstalled Werkzeug-1.0.1
Successfully installed werkzeug-0.16.1

(superset_demo) C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\bin>pip install flask-jwt-extended==3.18.1
Collecting flask-jwt-extended==3.18.1
  Using cached Flask-JWT-Extended-3.18.1.tar.gz (30 kB)
  Preparing metadata (setup.py) ... done
Requirement already satisfied: Werkzeug>=0.14 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask-jwt-extended==3.18.1) (0.16.1)
Requirement already satisfied: Flask in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask-jwt-extended==3.18.1) (1.1.4)
Requirement already satisfied: PyJWT>=1.6.4 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask-jwt-extended==3.18.1) (1.7.1)
Requirement already satisfied: six in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask-jwt-extended==3.18.1) (1.16.0)
Requirement already satisfied: Jinja2<3.0,>=2.10.1 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from Flask->flask-jwt-extended==3.18.1) (2.11.3)
Requirement already satisfied: click<8.0,>=5.1 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from Flask->flask-jwt-extended==3.18.1) (7.1.2)
Requirement already satisfied: itsdangerous<2.0,>=0.24 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from Flask->flask-jwt-extended==3.18.1) (1.1.0)
Requirement already satisfied: MarkupSafe>=0.23 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from Jinja2<3.0,>=2.10.1->Flask->flask-jwt-extended==3.18.1) (2.0.1)
Building wheels for collected packages: flask-jwt-extended
  Building wheel for flask-jwt-extended (setup.py) ... done
  Created wheel for flask-jwt-extended: filename=Flask_JWT_Extended-3.18.1-py2.py3-none-any.whl size=20463 sha256=f60187a3c5cbc5f13aeb17db8e0aa3a5d6a2ad667b4c4a574641fd187e135690
  Stored in directory: c:\users\chenw\appdata\local\pip\cache\wheels\c6\8b\72\2cf3abeac1d585084181f02272cf58f9674c682339a15bd2fa
Successfully built flask-jwt-extended
Installing collected packages: flask-jwt-extended
  Attempting uninstall: flask-jwt-extended
    Found existing installation: Flask-JWT-Extended 3.25.1
    Uninstalling Flask-JWT-Extended-3.25.1:
      Successfully uninstalled Flask-JWT-Extended-3.25.1
Successfully installed flask-jwt-extended-3.18.1

(superset_demo) C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\bin>pip install flask==0.12.5
Collecting flask==0.12.5
  Using cached Flask-0.12.5-py2.py3-none-any.whl (81 kB)
Requirement already satisfied: itsdangerous>=0.21 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask==0.12.5) (1.1.0)
Requirement already satisfied: Werkzeug<1.0,>=0.7 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask==0.12.5) (0.16.1)
Requirement already satisfied: click>=2.0 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask==0.12.5) (7.1.2)
Requirement already satisfied: Jinja2>=2.4 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask==0.12.5) (2.11.3)
Requirement already satisfied: MarkupSafe>=0.23 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from Jinja2>=2.4->flask==0.12.5) (2.0.1)
Installing collected packages: flask
  Attempting uninstall: flask
    Found existing installation: Flask 1.1.4
    Uninstalling Flask-1.1.4:
      Successfully uninstalled Flask-1.1.4
ERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the following dependency conflicts.
apache-superset 0.36.0 requires flask<2.0.0,>=1.1.0, but you have flask 0.12.5 which is incompatible.
Successfully installed flask-0.12.5

(superset_demo) C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\bin>pip install sqlalchemy==1.2.18
Collecting sqlalchemy==1.2.18
  Using cached SQLAlchemy-1.2.18.tar.gz (5.7 MB)
  Preparing metadata (setup.py) ... done
Building wheels for collected packages: sqlalchemy
  Building wheel for sqlalchemy (setup.py) ... done
  Created wheel for sqlalchemy: filename=SQLAlchemy-1.2.18-cp37-cp37m-win_amd64.whl size=1093579 sha256=003c277bbabd362984b5490b386a909e0fa8cbc5febc6fe4609b36f4e05df5e2
  Stored in directory: c:\users\chenw\appdata\local\pip\cache\wheels\36\4d\27\f9b8426126042afd747963af7bc141208e06fff1c29d9d6290
Successfully built sqlalchemy
Installing collected packages: sqlalchemy
  Attempting uninstall: sqlalchemy
    Found existing installation: SQLAlchemy 1.4.45
    Uninstalling SQLAlchemy-1.4.45:
      Successfully uninstalled SQLAlchemy-1.4.45
ERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the following dependency conflicts.
sqlalchemy-utils 0.39.0 requires SQLAlchemy>=1.3, but you have sqlalchemy 1.2.18 which is incompatible.
apache-superset 0.36.0 requires flask<2.0.0,>=1.1.0, but you have flask 0.12.5 which is incompatible.
apache-superset 0.36.0 requires sqlalchemy<2.0,>=1.3.5, but you have sqlalchemy 1.2.18 which is incompatible.
alembic 1.9.1 requires SQLAlchemy>=1.3.0, but you have sqlalchemy 1.2.18 which is incompatible.
Successfully installed sqlalchemy-1.2.18

(superset_demo) C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\bin>pip install superset==0.28.1
Collecting superset==0.28.1
  Using cached superset-0.28.1.tar.gz (52.7 MB)
ERROR: Could not install packages due to an OSError: [Errno 2] No such file or directory: 'C:\\Users\\chenw\\AppData\\Local\\Temp\\pip-install-7ekjolr6\\superset_25d99c453fa5453a92306303806eea4b\\superset/static/assets/dist/vendors-EventFlow-big_number-cal_heatmap-chord-country_map-directed_force-filter_box-heatmap-histogr-4abe76ce.fc10d2b92451bc9dbaf0.chunk.js'
HINT: This error might have occurred since this system does not have Windows Long Path support enabled. You can find information on how to enable this at https://pip.pypa.io/warnings/enable-long-paths


(superset_demo) C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\bin>fabmanager create-admin --app superset
fabmanager is going to be deprecated in 2.2.X, you can use the same commands on the improved 'flask fab <command>'
Username [admin]: admin
User first name [admin]: admin
User last name [user]: admin
Email [admin@fab.org]: chenwei@blemall.com
Password:
Repeat for confirmation:
Was unable to import superset Error: cannot import name 'inspect_getfullargspec' from 'sqlalchemy.util' (C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\sqlalchemy\util\__init__.py)

(superset_demo) C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\bin>pip install sqlalchemy
Requirement already satisfied: sqlalchemy in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (1.2.18)

(superset_demo) C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\bin>fabmanager create-admin --app superset
fabmanager is going to be deprecated in 2.2.X, you can use the same commands on the improved 'flask fab <command>'
Username [admin]: admin
User first name [admin]: admin
User last name [user]: admin
Email [admin@fab.org]: chenwei@blemall.com
Password:
Repeat for confirmation:
Was unable to import superset Error: cannot import name 'inspect_getfullargspec' from 'sqlalchemy.util' (C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\sqlalchemy\util\__init__.py)


(superset_demo) C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\bin>python superset db upgrade
Traceback (most recent call last):
  File "superset", line 18, in <module>
    from superset.cli import superset
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\superset\__init__.py", line 21, in <module>
    from superset.app import create_app
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\superset\app.py", line 29, in <module>
    from superset.extensions import (
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\superset\extensions.py", line 27, in <module>
    from flask_migrate import Migrate
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\flask_migrate\__init__.py", line 7, in <module>
    from alembic import __version__ as __alembic_version__
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\alembic\__init__.py", line 3, in <module>
    from . import context
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\alembic\context.py", line 1, in <module>
    from .runtime.environment import EnvironmentContext
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\alembic\runtime\environment.py", line 15, in <module>
    from .migration import _ProxyTransaction
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\alembic\runtime\migration.py", line 29, in <module>
    from .. import ddl
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\alembic\ddl\__init__.py", line 1, in <module>
    from . import mssql
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\alembic\ddl\mssql.py", line 17, in <module>
    from .base import AddColumn
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\alembic\ddl\base.py", line 16, in <module>
    from ..util.sqla_compat import _columns_for_constraint  # noqa
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\alembic\util\__init__.py", line 1, in <module>
    from .editor import open_in_editor
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\alembic\util\editor.py", line 13, in <module>
    from .compat import is_posix
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\alembic\util\compat.py", line 8, in <module>
    from sqlalchemy.util import inspect_getfullargspec  # noqa
ImportError: cannot import name 'inspect_getfullargspec' from 'sqlalchemy.util' (C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\sqlalchemy\util\__init__.py)

(superset_demo) C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\bin>pip install sqlalchemy==1.4.45
Collecting sqlalchemy==1.4.45
  Using cached SQLAlchemy-1.4.45-cp37-cp37m-win_amd64.whl (1.6 MB)
Requirement already satisfied: importlib-metadata in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from sqlalchemy==1.4.45) (5.2.0)
Requirement already satisfied: greenlet!=0.4.17 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from sqlalchemy==1.4.45) (2.0.1)
Requirement already satisfied: typing-extensions>=3.6.4 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from importlib-metadata->sqlalchemy==1.4.45) (4.4.0)
Requirement already satisfied: zipp>=0.5 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from importlib-metadata->sqlalchemy==1.4.45) (3.11.0)
Installing collected packages: sqlalchemy
  Attempting uninstall: sqlalchemy
    Found existing installation: SQLAlchemy 1.2.18
    Uninstalling SQLAlchemy-1.2.18:
      Successfully uninstalled SQLAlchemy-1.2.18
ERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the following dependency conflicts.
apache-superset 0.36.0 requires flask<2.0.0,>=1.1.0, but you have flask 0.12.5 which is incompatible.
Successfully installed sqlalchemy-1.4.45

(superset_demo) C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\bin>python superset db upgrade
Traceback (most recent call last):
  File "superset", line 18, in <module>
    from superset.cli import superset
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\superset\__init__.py", line 21, in <module>
    from superset.app import create_app
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\superset\app.py", line 29, in <module>
    from superset.extensions import (
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\superset\extensions.py", line 118, in <module>
    celery_app = celery.Celery()
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\celery\local.py", line 509, in __getattr__
    module = __import__(self._object_origins[name], None, None, [name])
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\celery\app\__init__.py", line 5, in <module>
    from celery import _state
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\celery\_state.py", line 17, in <module>
    from celery.utils.threads import LocalStack
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\celery\utils\__init__.py", line 19, in <module>
    from .nodenames import nodename, nodesplit, worker_direct
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\celery\utils\nodenames.py", line 9, in <module>
    from kombu.entity import Exchange, Queue
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\kombu\entity.py", line 9, in <module>
    from .serialization import prepare_accept_content
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\kombu\serialization.py", line 456, in <module>
    for ep, args in entrypoints('kombu.serializers'):  # pragma: no cover
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\kombu\utils\compat.py", line 93, in entrypoints
    for ep in importlib_metadata.entry_points().get(namespace, [])
AttributeError: 'EntryPoints' object has no attribute 'get'

(superset_demo) C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\bin>fabmanager create-admin --app superset
fabmanager is going to be deprecated in 2.2.X, you can use the same commands on the improved 'flask fab <command>'
Username [admin]: admin
User first name [admin]: admin
User last name [user]: admin
Email [admin@fab.org]: chenwei@blemall.com
Password:
Repeat for confirmation:
Was unable to import superset Error: 'EntryPoints' object has no attribute 'get'

(superset_demo) C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\bin>pip install importlib-metadata==4.13.0
Collecting importlib-metadata==4.13.0
  Downloading importlib_metadata-4.13.0-py3-none-any.whl (23 kB)
Requirement already satisfied: typing-extensions>=3.6.4 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from importlib-metadata==4.13.0) (4.4.0)
Requirement already satisfied: zipp>=0.5 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from importlib-metadata==4.13.0) (3.11.0)
Installing collected packages: importlib-metadata
  Attempting uninstall: importlib-metadata
    Found existing installation: importlib-metadata 5.2.0
    Uninstalling importlib-metadata-5.2.0:
      Successfully uninstalled importlib-metadata-5.2.0
ERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the following dependency conflicts.
apache-superset 0.36.0 requires flask<2.0.0,>=1.1.0, but you have flask 0.12.5 which is incompatible.
Successfully installed importlib-metadata-4.13.0

(superset_demo) C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\bin>pip install flask==1.1.4
Collecting flask==1.1.4
  Using cached Flask-1.1.4-py2.py3-none-any.whl (94 kB)
Requirement already satisfied: Jinja2<3.0,>=2.10.1 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask==1.1.4) (2.11.3)
Requirement already satisfied: itsdangerous<2.0,>=0.24 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask==1.1.4) (1.1.0)
Requirement already satisfied: click<8.0,>=5.1 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask==1.1.4) (7.1.2)
Requirement already satisfied: Werkzeug<2.0,>=0.15 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from flask==1.1.4) (0.16.1)
Requirement already satisfied: MarkupSafe>=0.23 in c:\users\chenw\anaconda3\envs\superset_demo\lib\site-packages (from Jinja2<3.0,>=2.10.1->flask==1.1.4) (2.0.1)
Installing collected packages: flask
  Attempting uninstall: flask
    Found existing installation: Flask 0.12.5
    Uninstalling Flask-0.12.5:
      Successfully uninstalled Flask-0.12.5
Successfully installed flask-1.1.4

(superset_demo) C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\bin>python superset db upgrade
logging was configured successfully
INFO:superset.utils.logging_configurator:logging was configured successfully
C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\flask_caching\__init__.py:120: UserWarning: Flask-Caching: CACHE_TYPE is set to null, caching is effectively disabled.
  "Flask-Caching: CACHE_TYPE is set to null, "
ERROR:flask_appbuilder.security.sqla.manager:DB Creation and initialization failed: get_bind() got an unexpected keyword argument 'bind'

(superset_demo) C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\bin>pip install sqlalchemy==1.3.24
Collecting sqlalchemy==1.3.24
  Downloading SQLAlchemy-1.3.24-cp37-cp37m-win_amd64.whl (1.2 MB)
     ---------------------------------------- 1.2/1.2 MB 1.4 MB/s eta 0:00:00
Installing collected packages: sqlalchemy
  Attempting uninstall: sqlalchemy
    Found existing installation: SQLAlchemy 1.4.45
    Uninstalling SQLAlchemy-1.4.45:
      Successfully uninstalled SQLAlchemy-1.4.45
Successfully installed sqlalchemy-1.3.24

(superset_demo) C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\bin>python superset db upgrade
logging was configured successfully
INFO:superset.utils.logging_configurator:logging was configured successfully
C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\flask_caching\__init__.py:120: UserWarning: Flask-Caching: CACHE_TYPE is set to null, caching is effectively disabled.
  "Flask-Caching: CACHE_TYPE is set to null, "
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
C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\alembic\ddl\sqlite.py:82: UserWarning: Skipping unsupported ALTER for creation of implicit constraint. Please refer to the batch mode feature which allows for SQLite migrations using a copy-and-move strategy.
  "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
C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\sqlalchemy\dialects\sqlite\base.py:2014: 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 -> 4451805bbaa1, remove double percents
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 4451805bbaa1, 1d9e835a84f9 -> e3970889f38e, empty message
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 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
INFO  [alembic.runtime.migration] Running upgrade b6fa807eac07 -> cca2f5d568c8, add encrypted_extra to dbs
INFO  [alembic.runtime.migration] Running upgrade cca2f5d568c8 -> c2acd2cf3df2, alter type of dbs encrypted_extra
INFO  [alembic.runtime.migration] Running upgrade c2acd2cf3df2 -> 78ee127d0d1d, reconvert legacy filters into adhoc
INFO  [alembic.runtime.migration] Running upgrade 78ee127d0d1d -> db4b49eb0782, Add tables for SQL Lab state
INFO  [alembic.runtime.migration] Running upgrade db4b49eb0782 -> 5afa9079866a, serialize_schema_permissions.py
INFO  [alembic.runtime.migration] Running upgrade 5afa9079866a -> 89115a40e8ea, Change table schema description to long text
INFO  [alembic.runtime.migration] Running upgrade 89115a40e8ea -> 817e1c9b09d0, add_not_null_to_dbs_sqlalchemy_url
INFO  [alembic.runtime.migration] Running upgrade 817e1c9b09d0 -> e96dbf2cfef0, datasource_cluster_fk
INFO  [alembic.runtime.migration] Running upgrade e96dbf2cfef0 -> 3325d4caccc8, empty message
INFO  [alembic.runtime.migration] Running upgrade 3325d4caccc8 -> 0a6f12f60c73, add_role_level_security
INFO  [alembic.runtime.migration] Running upgrade 0a6f12f60c73 -> 72428d1ea401, Add tmp_schema_name to the query object.
INFO  [alembic.runtime.migration] Running upgrade 72428d1ea401 -> b5998378c225, add certificate to dbs
INFO  [alembic.runtime.migration] Running upgrade b5998378c225 -> f9a30386bd74, cleanup_time_grainularity

(superset_demo) C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\bin>python superset fab create-admin
logging was configured successfully
INFO:superset.utils.logging_configurator:logging was configured successfully
C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\flask_caching\__init__.py:120: UserWarning: Flask-Caching: CACHE_TYPE is set to null, caching is effectively disabled.
  "Flask-Caching: CACHE_TYPE is set to null, "
Username [admin]: admin
User first name [admin]: admin
User last name [user]: admin
Email [admin@fab.org]: chenwei@blemall.com
Password:123456
Repeat for confirmation:123456
Recognized Database Authentications.
Admin User admin created.

(superset_demo) C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\bin>python superset load_examples
logging was configured successfully
INFO:superset.utils.logging_configurator:logging was configured successfully
C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\flask_caching\__init__.py:120: UserWarning: Flask-Caching: CACHE_TYPE is set to null, caching is effectively disabled.
  "Flask-Caching: CACHE_TYPE is set to null, "
Creating database reference for examples
INFO:superset.utils.core:Creating database reference for examples
Loading examples metadata and related data into examples
Creating default CSS templates
Loading energy related dataset
Traceback (most recent call last):
  File "superset", line 21, in <module>
    superset()
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\click\core.py", line 829, in __call__
    return self.main(*args, **kwargs)
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\flask\cli.py", line 586, in main
    return super(FlaskGroup, self).main(*args, **kwargs)
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\click\core.py", line 782, in main
    rv = self.invoke(ctx)
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\click\core.py", line 1259, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\click\core.py", line 1066, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\click\core.py", line 610, in invoke
    return callback(*args, **kwargs)
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\click\decorators.py", line 21, in new_func
    return f(get_current_context(), *args, **kwargs)
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\flask\cli.py", line 426, in decorator
    return __ctx.invoke(f, *args, **kwargs)
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\click\core.py", line 610, in invoke
    return callback(*args, **kwargs)
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\superset\cli.py", line 165, in load_examples
    load_examples_run(load_test_data, only_metadata, force)
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\superset\cli.py", line 105, in load_examples_run
    examples.load_energy(only_metadata, force)
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\superset\examples\energy.py", line 39, in load_energy
    data = get_example_data("energy.json.gz")
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\superset\examples\helpers.py", line 71, in get_example_data
    content = request.urlopen(f"{BASE_URL}{filepath}?raw=true").read()
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\urllib\request.py", line 222, in urlopen
    return opener.open(url, data, timeout)
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\urllib\request.py", line 531, in open
    response = meth(req, response)
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\urllib\request.py", line 641, in http_response
    'http', request, response, code, msg, hdrs)
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\urllib\request.py", line 563, in error
    result = self._call_chain(*args)
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\urllib\request.py", line 503, in _call_chain
    result = func(*args)
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\urllib\request.py", line 755, in http_error_302
    return self.parent.open(new, timeout=req.timeout)
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\urllib\request.py", line 525, in open
    response = self._open(req, data)
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\urllib\request.py", line 543, in _open
    '_open', req)
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\urllib\request.py", line 503, in _call_chain
    result = func(*args)
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\urllib\request.py", line 1393, in https_open
    context=self._context, check_hostname=self._check_hostname)
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\urllib\request.py", line 1353, in do_open
    r = h.getresponse()
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\http\client.py", line 1373, in getresponse
    response.begin()
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\http\client.py", line 319, in begin
    version, status, reason = self._read_status()
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\http\client.py", line 280, in _read_status
    line = str(self.fp.readline(_MAXLINE + 1), "iso-8859-1")
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\socket.py", line 589, in readinto
    return self._sock.recv_into(b)
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\ssl.py", line 1071, in recv_into
    return self.read(nbytes, buffer)
  File "C:\Users\chenw\anaconda3\envs\superset_demo\lib\ssl.py", line 929, in read
    return self._sslobj.read(len, buffer)
TimeoutError: [WinError 10060] 由于连接方在一段时间后没有正确答复或连接的主机没有反应，连接尝试失败。

(superset_demo) C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\bin>python superset init
logging was configured successfully
INFO:superset.utils.logging_configurator:logging was configured successfully
C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\flask_caching\__init__.py:120: UserWarning: Flask-Caching: CACHE_TYPE is set to null, caching is effectively disabled.
  "Flask-Caching: CACHE_TYPE is set to null, "
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

(superset_demo) C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\bin>python superset run -p 8088 --with-threads --reload --debugger
logging was configured successfully
INFO:superset.utils.logging_configurator:logging was configured successfully
C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\flask_caching\__init__.py:120: UserWarning: Flask-Caching: CACHE_TYPE is set to null, caching is effectively disabled.
  "Flask-Caching: CACHE_TYPE is set to null, "
 * Environment: production
   WARNING: This is a development server. Do not use it in a production deployment.
   Use a production WSGI server instead.
 * Debug mode: off
INFO:werkzeug: * Restarting with stat
logging was configured successfully
INFO:superset.utils.logging_configurator:logging was configured successfully
C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\flask_caching\__init__.py:120: UserWarning: Flask-Caching: CACHE_TYPE is set to null, caching is effectively disabled.
  "Flask-Caching: CACHE_TYPE is set to null, "
WARNING:werkzeug: * Debugger is active!
INFO:werkzeug: * Debugger PIN: 268-080-422
INFO:werkzeug: * Running on http://127.0.0.1:8088/ (Press CTRL+C to quit)
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:36] "GET / HTTP/1.1" 302 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:36] "GET /superset/welcome HTTP/1.1" 302 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:36] "GET /login/ HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:36] "GET /static/appbuilder/datepicker/bootstrap-datepicker.css HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:36] "GET /static/appbuilder/css/ab.css HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:36] "GET /static/appbuilder/css/flags/flags16.css HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:36] "GET /static/appbuilder/css/font-awesome.min.css HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:36] "GET /static/appbuilder/select2/select2.css HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:36] "GET /static/appbuilder/css/bootstrap.min.css HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:36] "GET /static/assets/theme.e76619c6a440fc07fa28.entry.css HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:36] "GET /static/appbuilder/js/ab_filters.js HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:36] "GET /static/appbuilder/js/ab_actions.js HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:36] "GET /static/assets/theme.e76619c6a440fc07fa28.entry.js HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:36] "GET /static/appbuilder/js/jquery-latest.js HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:36] "GET /static/appbuilder/datepicker/bootstrap-datepicker.js HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:36] "GET /static/appbuilder/js/bootstrap.min.js HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:36] "GET /static/appbuilder/js/ab.js HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:36] "GET /static/appbuilder/select2/select2.js HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:36] "GET /static/assets/vendors-addSlice-preamble-profile-showSavedQuery-sqllab-welcome.7e152e5dd5d1e28b7651.chunk.js HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:36] "GET /static/assets/preamble.e22606bd0dac72848a12.entry.js HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:36] "GET /static/assets/images/superset-logo@2x.png HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:36] "GET /static/appbuilder/img/flags/flags16.png HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:36] "GET /static/assets/vendors-major.26c6716120c96d10daf2.chunk.js HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:36] "GET /static/assets/1e081edc16d92d42aeccec760174fbf4.woff2 HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:36] "GET /static/appbuilder/fonts/fontawesome-webfont.woff2?v=4.7.0 HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:36] "GET /static/assets/e7ae98681edfa1df7f1e3ebba0d4fb88.woff2 HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:36] "GET /static/assets/images/favicon.png HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:42] "POST /login/ HTTP/1.1" 302 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:42] "GET /login/ HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:49] "POST /login/ HTTP/1.1" 302 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:49] "GET / HTTP/1.1" 302 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:50] "GET /superset/welcome HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:50] "GET /static/assets/images/loading.gif HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:50] "GET /static/assets/welcome.cb9ef677374cffc1955d.entry.css HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:50] "GET /static/assets/welcome.cb9ef677374cffc1955d.entry.js HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:50] "GET /superset/fave_dashboards/1/ HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:50] "GET /superset/fave_slices/1/ HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:50] "GET /superset/recent_activity/1/?limit=50 HTTP/1.1" 200 -
INFO:werkzeug:127.0.0.1 - - [27/Dec/2022 09:45:50] "GET /api/v1/dashboard/?q={%22order_column%22:%22changed_on%22,%22order_direction%22:%22desc%22,%22page%22:0,%22page_size%22:25} HTTP/1.1" 200 -

5）、superset启动脚本

非必需，也可以在安装目录下直接执行该启动命令

为了快捷启动superset，我们可以编写简单的脚本bat文件

call cd C:\Users\chenw\anaconda3\envs\superset_demo\lib\site-packages\superset\bin
call activate superset_demo
call python superset run -p 8088 --with-threads --reload --debugger

pause

4、验证

1）、web UI验证

在浏览器中输入http://127.0.0.1:8088/dashboard/list/
输入设置的用户名和密码，登录即可

在这里插入图片描述

2）、添加数据源

ERROR:superset.views.core:Unexpected error No module named 'MySQLdb'

# MySQLdb只支持Python2.，还不支持3..可以用PyMySQL代替
#解决方法：
#执行 pip install PyMySQL，将数据库连接改为
mysql+pymysql://root:123455@192.168.10.44/test?charset=utf8

(superset_demo) C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\bin>pip install PyMySQL
Collecting PyMySQL
  Downloading PyMySQL-1.0.2-py3-none-any.whl (43 kB)
     ---------------------------------------- 43.8/43.8 kB 533.1 kB/s eta 0:00:00
Installing collected packages: PyMySQL
Successfully installed PyMySQL-1.0.2

在这里插入图片描述

在SQL工具箱编写sql 查询时出现异常，通过后台运行日志看到如下图

AttributeError: module 'signal' has no attribute 'SIGALRM'
# 原因是Python 的 signal 包只作用于 Linux 和 Mac ，在 Windows 下不启作用。
#解决方法
#根据日志找到报错的地方
File "C:\Users\chenw\anaconda3\envs\superset_demo\Lib\site-packages\superset\utils\core.py", line 584, in __enter__
    signal.signal(signal.SIGALRM, self.handle_timeout)
AttributeError: module 'signal' has no attribute 'SIGALRM'
#新的版本的代码已经由 supsert\utils.py 变更到 superset\utils\core.py 
  #将 
     def __enter__(self):
        try:
            signal.signal(signal.SIGALRM, self.handle_timeout)
            signal.alarm(self.seconds)
        except ValueError as e:
            logger.warning("timeout can't be used in the current context")
            logger.exception(e)

    def __exit__(self, type, value, traceback):
        try:
            signal.alarm(0)
        except ValueError as e:
            logger.warning("timeout can't be used in the current context")
            logger.exception(e)   
     
  #替换为：    
        def __enter__(self):
        try:
            pass
            #signal.signal(signal.SIGALRM, self.handle_timeout)
            #signal.alarm(self.seconds)
        except ValueError as e:
            logging.warning("timeout can't be used in the current context")
            logging.exception(e)

    def __exit__(self, type, value, traceback):
        try:
            pass
            #signal.alarm(0)
        except ValueError as e:
            logging.warning("timeout can't be used in the current context")
            logging.exception(e)
# 然后重启
python superset run -p 8088 --with-threads --reload --debugger

再次访问，正常
在这里插入图片描述
以上，简单的介绍了superset的功能、应用场景以及部署和验证。

一瓢一瓢的饮 alanchanchn
关注
专栏目录
Superset二次开发之环境部署（Windows版）
Aimmon
12-26 1454
本地环境版本介绍:编号名称版本。
Superset在windows下的安装配置及基础教程
烂笔头的专栏
11-15 4241
官方教程：http://superset.apache.org/tutorial.html Superset是由Airbnb（知名在线房屋短租公司）开源BI数据分析与可视化平台（曾用名Caravel、Panoramix），该工具主要特点是可自助分析、自定义仪表盘、分析结果可视化（导出）、用户/角色权限控制，还集成了一个SQL编辑器，可以进行SQL编辑查询等，原来是用于支持Druid的可视化分析，...
Superset部署
千锋教育
07-27 379
说明：gunicorn是一个Python Web Server，可以和java中的Tomcat类比。：flask是一个python web框架，Superset使用的就是flask。说明：pip是python的包管理工具，可以和centos中的yum类比。在里面可以设置用户名与密码，其他的可以不用设置，直接enter就行。上面我每一个都设置的root，也就是以后我们登录Web界面的时候，采用的数据库是sqllite数据库，是一个轻量级的数据量。说明：-i的作用是指定镜像，这里选择国内镜像。
Superset【部署 01】在线安装数据可视化图表工具 Superset（Python虚拟环境部署+问题解决+WEB登录配置+官方图表展示）
最新发布
Java与大数据相关实践内容分享！
07-29 1235
Apache Superset 是一个可用于数据展示与可视化的开源软件，在处理大量数据方面效果显著。Superset 最初为 Airbnb 所开发，在2017年成为Apache的孵化项目。一个直观的界面可视化数据集和制作交互式仪表板一个广泛的美丽的可视化阵列来展示您的数据无代码的可视化构建器，提取和呈现数据集为可视化准备数据的世界级SQL IDE，包括丰富的元数据浏览器轻量级语义层，使数据分析人员能够快速定义定制的维度和指标支持多数数据库SQL语言的开箱即用。
superset安装和部署(超详细)
m0_74756715的博客
11-21 7933
Apache Superset是一个开源的、现代的、轻量级BI分析工具，能够对接多种数据源、拥有丰富的图表展示形式、支持自定义仪表盘，且拥有友好的用户界面，十分易用。
superset开发环境搭建
netbloomy的专栏
03-09 4583
在对superset进行二次开发的过程中，往往需要搭建本地开发环境，修改后立即看到效果，下面我们就讲下开发环境的搭建。
idea配置vue开发环境
drinkworld的博客
10-22 9446
1.下载node.js 下载地址：https://nodejs.org/zh-cn/ 2.安装nodejs 默认安装即可。 安装完毕后，测试安装是否成功。 3.修改镜像库位国内淘宝镜像 npm config set registry http://registry.npm.taobao.org 4.安装webpack npm install -g webpack 5.安装vue-cli npm install -g vue-cli 6.进入项目目录，安装依赖 npm install 7.idea配置
superset离线部署文档（python3.4.2+centos6.8）.docx
03-09
Offline Deployment of Superset with Python 3.4.2 and CentOS 6.8 在此文档中，我们将讲述如何离线部署 Superset，以 Python ...通过以上步骤，我们可以离线部署 Superset，以 Python 3.4.2 和 CentOS 6.8 为基础。
superset2.0在Windows环境和Linux环境下的安装配置
08-10
superset2.0在Windows环境和Linux环境下的安装配置
Windows安装Superset基本步骤
Aurora_lina的博客
05-27 4519
Windows系统安装Superset 一、安装环境 Windows10系统 Anaconda环境 3.7或3.8版本 Python 3.7或3.8版本 Superset安装 Superset官网：https://superset.apache.org/ # Anaconda下载 # 官方下载地址： https://www.anaconda.com/products/individual#Downloads 清华大学镜像下载地址：https://mirrors.tuna.tsinghua.edu.cn
SuperSet安装部署手册
05-17
Superset 是 Airbnb （知名在线房屋短租公司）开源的数据探查与可视化平台（曾用名 Panoramix、Caravel ），该工具在可视化、易用性和交互性上非常有特色，用户可以轻松对数据进行可视化分析。
ubuntu+pycharm搭建incubator-superset开发环境
12-23
前言 网上关于superset开发环境搭建的教程有很多，但是基本都已经过时不可用了，所以发出来这篇最新教程，希望大家少走一些弯路。 开发环境：ubuntu 19.10 + pycharm 2019.3.3  + python 3.7 项目版本信息：release分支 0.35.2 一、环境准备 1. 克隆项目到本地： git clone https://github.com/apache/incubator-superset 2. 准备环境，安装必要的工具包： sudo apt-get install build-essential libssl-dev libffi-dev python
Python安装配置apache-superset
什么都干的派森
12-06 1461
2.启动容器 ps：注意端口占用，当前部署在 8080 端口上了，确保宿主机端口未被占用，不行就换其他端口 ps：用户名和密码都是 admin，一会用于登录，其他随便填 5.下载一个官方提供的样例数据库【可跳过】 ps：此步国内无法访问，一般下载不了，能下的就下，不能下的跳过就行了，一会配置自己的数据库 7.访问登录页面 ps：注意端口是上面自己配置的端口，账号密码是 admin依次点击 Settings → Database Connections 点击 DATABASE 就可以配置自己的数据库了
superset部署
shepocangqiong的博客
03-02 467
Superset安装 使用conda配置虚拟环境 conda create -n superset python=3.8 进入创建的环境 conda activate superst 安装superset pip install apache-superset 配置账号 flask fab create-admin 弹出内容依次填写，例： Username [admin]: admin User first name [admin]: admin User last name [user]: adm
superset的安装部署
morsunlight的博客
02-04 198
https://blog.csdn.net/qq_43565204/article/details/106232918
superset安装部署
缘字诀的博客
12-30 503
superset安装部署 安装Python3环境准备的包 [root@JD /]# yum -y install zlib-devel bzip2-devel openssl-devel ncurses-devel sqlite-devel readline-devel tk-devel gdbm-devel db4-devel libpcap-devel xz-devel [root@JD s...
Superset 开发环境搭建
有关心情
09-08 1105
Superset 开发环境搭建 文章目录Superset 开发环境搭建起步设置静态 IPCentos7 更换源Python3.6 安装pip 国内源npm 安装Superset 安装Pycharm 调试参考 起步 该教程从虚拟机装完 Centos7 开始。此次环境搭建在 /opt 目录下。 文件夹中的代码具有时效性，无法做到与 github 上的开源项目 superset 时时一致。现在时间是 0...
CentOS7安装Python3与Superset详细步骤
"在CentOS7环境下安装Python和Superset的过程涉及多个步骤，包括检查现有Python版本、安装必要的包管理工具、创建虚拟环境以及安装Superset本身。" 在CentOS7操作系统中，通常系统会预装一个Python版本，你可以通过...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

一瓢一瓢的饮 alanchanchn

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值