windows环境搭建Superset问题集锦

环境：win10专业版 64位操作系统

python: 3.8.10

node: v16.15.1

一、后端问题

1、pip install -e .  -i https://pypi.douban.com/simple --trusted-host pypi.douban.com

error: subprocess-exited-with-error

pip subprocess to install build dependencies did not run successfully.

具体报错如下：

Installing build dependencies ... error
  error: subprocess-exited-with-error

  × pip subprocess to install build dependencies did not run successfully.
  │ exit code: 1
  ╰─> [290 lines of output]
      Looking in indexes: https://pypi.douban.com/simple
      Ignoring numpy: markers 'python_version < "3.9"' don't match your environment
      Collecting cython>=0.29
        Downloading https://pypi.doubanio.com/packages/80/08/1c007f1d571f8f2a67ed6938cc79117fa5ae9c0d9ff633fbd5e52f212062/Cython-0.29.30-py2.py3-none-any.whl (985 kB)
           -------------------------------------- 985.1/985.1 kB 1.4 MB/s eta 0:00:00
      Collecting numpy==1.19.4
        Downloading https://pypi.doubanio.com/packages/c5/63/a48648ebc57711348420670bb074998f79828291f68aebfff1642be212ec/numpy-1.19.4.zip (7.3 MB)
           ---------------------------------------- 7.3/7.3 MB 1.7 MB/s eta 0:00:00
        Installing build dependencies: started
        Installing build dependencies: finished with status 'done'
        Getting requirements to build wheel: started
        Getting requirements to build wheel: finished with status 'done'
        Preparing metadata (pyproject.toml): started
        Preparing metadata (pyproject.toml): finished with status 'error'
        error: subprocess-exited-with-error

        Preparing metadata (pyproject.toml) did not run successfully.
        exit code: 1

        [259 lines of output]
        setup.py:67: RuntimeWarning: NumPy 1.19.4 may not yet support Python 3.10.
          warnings.warn(
        Running from numpy source directory.
        setup.py:480: UserWarning: Unrecognized setuptools command, proceeding with generating Cython sources and expanding templates。。。。

查看原因Ignoring numpy: markers 'python_version < "3.9"' don't match your environment

主要是镜像下python环境与本地python环境不匹配

当前环境为3.10.5，所以采用降级的方式，这里选取3.8.10，下载地址Python Releases for Windows | Python.org

下载成功后，重新设置下环境变量，创建的虚拟环境需得重新创建，再执行下载就可以了

2、执行superset db upgrade报错

ModuleNotFoundError: No module named 'werkzeug.wrappers.etag'

主要是找不到相应模块，Werkzeug指定下载2.0.0的就可以了

解决pip install Werkzeug==2.0.0 -i https://pypi.douban.com/simple --trusted-host pypi.douban.com

3、想要删除数据库重新执行

默认地址C:\Users\xxx\.superset

 4.superset load-examples失败解决方法

查看这里superset load-examples失败解决方法_布鲁布鲁特的博客-CSDN博客

5.superset load-examples 异常

superset.exceptions.NoDataException: Admin user does not exist. Please, check if test users are properly loaded (`superset load_test_users`).

不存在一个admin的用户，猜测数据库需要指定名为admin的用户

解决：参照问题3删除数据库重新初始化，再在创建用户的时候指定写admin

二、前端问题

1、【npm错误】- npm ERR code ERESOLVE 和 npm ERR ERESOLVE could not resolve 问题

错误：Conflicting peer dependency: webpack@4.46.0 npm ERR

解决：npm install  --legacy-peer-deps

2、Cannot read properties of null (reading ‘pickAlgorithm‘)

解决：npm cache clear --force