开源的数据探查与可视化平台superset

苏生不惑

安装 pip superset

curl https://bootstrap.pypa.io/get-pip.py -o get-pip.py
python get-pip.py
λ pip install superset
Collecting superset
  Downloading https://files.pythonhosted.org/packages/80/98/8ffd47f4b68b11d00e0cad5a3a61b4e28a56bd79c47623c8c31e04faa8cb/superset-0.28.0.tar.gz (52.7MB)
    100% |████████████████████████████████| 52.7MB 88kB/s
Requirement already satisfied: bleach in d:\python\lib\site-packages (from superset) (2.1.4)
Requirement already satisfied: boto3==1.4.7 in d:\python\lib\site-packages (from superset) (1.4.7)
Requirement already satisfied: botocore<1.8.0,>=1.7.0 in d:\python\lib\site-packages (from superset) (1.7.48)
Requirement already satisfied: celery>=4.2.0 in d:\python\lib\site-packages (from superset) (4.2.1)
Requirement already satisfied: click==6.7 in d:\python\lib\site-packages (from superset) (6.7)

Requirement already satisfied: colorama==0.3.9 in d:\python\lib\site-packages (from superset) (0.3.9)
Requirement already satisfied: contextlib2 in d:\python\lib\site-packages (from superset) (0.5.5)
Requirement already satisfied: cryptography in d:\python\lib\site-packages (from superset) (2.3.1)
Requirement already satisfied: flask<1.0.0 in d:\python\lib\site-packages (from superset) (0.12.4)
Collecting flask-appbuilder>=1.12.0 (from superset)
  Retrying (Retry(total=4, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ProtocolError('Connection aborted.', ConnectionResetError(10054, '远程主机强迫
关闭了一个现有的连接。', None, 10054, None))': /simple/flask-appbuilder/
  Downloading https://files.pythonhosted.org/packages/ca/7b/a4c899095e1ca0eb732cca22934ce483b78b05329f37b97ae0e6e0e3f386/Flask-AppBuilder-1.12.1.tar.gz (2.3MB)
    100% |████████████████████████████████| 2.3MB 63kB/s
Requirement already satisfied: flask-caching in d:\python\lib\site-packages (from superset) (1.4.0)
Requirement already satisfied: flask-compress in d:\python\lib\site-packages (from superset) (1.4.0)
Requirement already satisfied: flask-migrate in d:\python\lib\site-packages (from superset) (2.2.1)
Requirement already satisfied: flask-wtf in d:\python\lib\site-packages (from superset) (0.14.2)
Requirement already satisfied: flower in d:\python\lib\site-packages (from superset) (0.9.2)
Requirement already satisfied: future<0.17,>=0.16.0 in d:\python\lib\site-packages (from superset) (0.16.0)
Requirement already satisfied: geopy in d:\python\lib\site-packages (from superset) (1.16.0)
Requirement already satisfied: gunicorn in d:\python\lib\site-packages (from superset) (19.9.0)
Requirement already satisfied: humanize in d:\python\lib\site-packages (from superset) (0.5.1)

Requirement already satisfied: idna in d:\python\lib\site-packages (from superset) (2.7)
Requirement already satisfied: isodate in d:\python\lib\site-packages (from superset) (0.6.0) Collecting markdown>=3.0 (from superset)
  Downloading https://files.pythonhosted.org/packages/7a/6b/5600647404ba15545ec37d2f7f58844d690baf2f81f3a60b862e48f29287/Markdown-3.0.1-py2.py3-none-any.whl (89kB)
    100% |████████████████████████████████| 92kB 38kB/s
Requirement already satisfied: pandas>=0.18.0 in d:\python\lib\site-packages (from superset) (0.23.4)
Requirement already satisfied: parsedatetime in d:\python\lib\site-packages (from superset) (2.4)
Requirement already satisfied: pathlib2 in d:\python\lib\site-packages (from superset) (2.3.2)

Requirement already satisfied: polyline in d:\python\lib\site-packages (from superset) (1.3.2)

Requirement already satisfied: pydruid>=0.4.3 in d:\python\lib\site-packages (from superset) (0.4.5)
Requirement already satisfied: pyhive>=0.4.0 in d:\python\lib\site-packages (from superset) (0.6.0)
Requirement already satisfied: python-dateutil in d:\python\lib\site-packages (from superset) (2.7.3)
Requirement already satisfied: python-geohash in d:\python\lib\site-packages (from superset) (0.8.5)
Requirement already satisfied: pyyaml>=3.11 in d:\python\lib\site-packages (from superset) (3.13)
Requirement already satisfied: requests in d:\python\lib\site-packages (from superset) (2.19.1)
Requirement already satisfied: simplejson>=3.15.0 in d:\python\lib\site-packages (from superset) (3.16.0)
Requirement already satisfied: sqlalchemy in d:\python\lib\site-packages (from superset) (1.2.11)
Requirement already satisfied: sqlalchemy-utils in d:\python\lib\site-packages (from superset) (0.33.3)
Requirement already satisfied: sqlparse in d:\python\lib\site-packages (from superset) (0.2.4)

Collecting tableschema (from superset)
  Downloading https://files.pythonhosted.org/packages/28/29/2fd3744510a745bee4735bd34cb44f9a0cc02e646d929a40aa5b2f8b85d8/tableschema-1.2.5-py2.py3-none-any.whl (55kB)
    100% |████████████████████████████████| 61kB 77kB/s
Requirement already satisfied: thrift>=0.9.3 in d:\python\lib\site-packages (from superset) (0.11.0)
Requirement already satisfied: thrift-sasl>=0.2.1 in d:\python\lib\site-packages (from superset) (0.3.0)
Requirement already satisfied: unicodecsv in d:\python\lib\site-packages (from superset) (0.14.1)
Requirement already satisfied: unidecode>=0.04.21 in d:\python\lib\site-packages (from superset) (1.0.22)
Requirement already satisfied: html5lib!=1.0b1,!=1.0b2,!=1.0b3,!=1.0b4,!=1.0b5,!=1.0b6,!=1.0b7,!=1.0b8,>=0.99999999pre in d:\python\lib\site-packages (from bleach->superset) (1.0.1)
Requirement already satisfied: six in d:\python\lib\site-packages (from bleach->superset) (1.11.0)
Requirement already satisfied: jmespath<1.0.0,>=0.7.1 in d:\python\lib\site-packages (from boto3==1.4.7->superset) (0.9.3)
Requirement already satisfied: s3transfer<0.2.0,>=0.1.10 in d:\python\lib\site-packages (from boto3==1.4.7->superset) (0.1.13)
Requirement already satisfied: docutils>=0.10 in d:\python\lib\site-packages (from botocore<1.8.0,>=1.7.0->superset) (0.14)
Requirement already satisfied: pytz>dev in d:\python\lib\site-packages (from celery>=4.2.0->superset) (2018.5)
Requirement already satisfied: billiard<3.6.0,>=3.5.0.2 in d:\python\lib\site-packages (from celery>=4.2.0->superset) (3.5.0.4)
Requirement already satisfied: kombu<5.0,>=4.2.0 in d:\python\lib\site-packages (from celery>=4.2.0->superset) (4.2.1)
Requirement already satisfied: asn1crypto>=0.21.0 in d:\python\lib\site-packages (from cryptography->superset) (0.24.0)
Requirement already satisfied: cffi!=1.11.3,>=1.7 in d:\python\lib\site-packages (from cryptography->superset) (1.11.5)
Requirement already satisfied: Jinja2>=2.4 in d:\python\lib\site-packages (from flask<1.0.0->superset) (2.10)
Requirement already satisfied: itsdangerous>=0.21 in d:\python\lib\site-packages (from flask<1.0.0->superset) (0.24)
Requirement already satisfied: Werkzeug>=0.7 in d:\python\lib\site-packages (from flask<1.0.0->superset) (0.14.1)
Requirement already satisfied: Flask-Babel<1,>=0.11.1 in d:\python\lib\site-packages (from flask-appbuilder>=1.12.0->superset) (0.11.1)
Collecting Flask-Login<0.5,>=0.3 (from flask-appbuilder>=1.12.0->superset)
  Downloading https://files.pythonhosted.org/packages/c1/ff/bd9a4d2d81bf0c07d9e53e8cd3d675c56553719bbefd372df69bf1b3c1e4/Flask-Login-0.4.1.tar.gz
Requirement already satisfied: Flask-OpenID<2,>=1.2.5 in d:\python\lib\site-packages (from flask-appbuilder>=1.12.0->superset) (1.2.5)
Collecting Flask-SQLAlchemy<3,>=2.3 (from flask-appbuilder>=1.12.0->superset)
  Downloading https://files.pythonhosted.org/packages/a1/44/294fb7f6bf49cc7224417cd0637018db9fee0729b4fe166e43e2bbb1f1c8/Flask_SQLAlchemy-2.3.2-py2.py3-none-any.whl
Requirement already satisfied: alembic>=0.7 in d:\python\lib\site-packages (from flask-migrate->superset) (1.0.0)
Requirement already satisfied: WTForms in d:\python\lib\site-packages (from flask-wtf->superset) (2.2.1)
Requirement already satisfied: tornado>=4.2.0 in d:\python\lib\site-packages (from flower->superset) (5.1)
Requirement already satisfied: babel>=1.0 in d:\python\lib\site-packages (from flower->superset) (2.6.0)
Requirement already satisfied: geographiclib<2,>=1.49 in d:\python\lib\site-packages (from geopy->superset) (1.49)
Requirement already satisfied: numpy>=1.9.0 in d:\python\lib\site-packages (from pandas>=0.18.0->superset) (1.15.1)
Requirement already satisfied: certifi>=2017.4.17 in d:\python\lib\site-packages (from requests->superset) (2018.8.24)
Requirement already satisfied: chardet<3.1.0,>=3.0.2 in d:\python\lib\site-packages (from requests->superset) (3.0.4)
Requirement already satisfied: urllib3<1.24,>=1.21.1 in d:\python\lib\site-packages (from requests->superset) (1.23)
Requirement already satisfied: jsonschema<3.0,>=2.5 in d:\python\lib\site-packages (from tableschema->superset) (2.6.0)
Requirement already satisfied: rfc3986<2.0,>=1.1.0 in d:\python\lib\site-packages (from tableschema->superset) (1.1.0)
Collecting tabulator<2.0,>=1.3 (from tableschema->superset)
  Downloading https://files.pythonhosted.org/packages/63/a6/33d0b08ce84fd1cdf0fb57e81bc822345007dd698cc5273b7ef916fce5ed/tabulator-1.17.0-py2.py3-none-any.whl (50kB)
    100% |████████████████████████████████| 51kB 168kB/s
Requirement already satisfied: pure-sasl>=0.3.0 in d:\python\lib\site-packages (from thrift-sasl>=0.2.1->superset) (0.5.1)
Requirement already satisfied: webencodings in d:\python\lib\site-packages (from html5lib!=1.0b1,!=1.0b2,!=1.0b3,!=1.0b4,!=1.0b5,!=1.0b6,!=1.0b7,!=1.0b8,>=0.99999999pre->bleach->superset) (0.5.1)
Requirement already satisfied: amqp<3.0,>=2.1.4 in d:\python\lib\site-packages (from kombu<5.0,>=4.2.0->celery>=4.2.0->superset) (2.3.2)
Requirement already satisfied: pycparser in d:\python\lib\site-packages (from cffi!=1.11.3,>=1.7->cryptography->superset) (2.18)
Requirement already satisfied: MarkupSafe>=0.23 in d:\python\lib\site-packages (from Jinja2>=2.4->flask<1.0.0->superset) (1.0)
Requirement already satisfied: python3-openid>=2.0 in d:\python\lib\site-packages (from Flask-OpenID<2,>=1.2.5->flask-appbuilder>=1.12.0->superset) (3.1.0)
Requirement already satisfied: python-editor>=0.3 in d:\python\lib\site-packages (from alembic>=0.7->flask-migrate->superset) (1.0.3)
Requirement already satisfied: Mako in d:\python\lib\site-packages (from alembic>=0.7->flask-migrate->superset) (1.0.7)
Requirement already satisfied: xlrd<2.0,>=1.0 in d:\python\lib\site-packages (from tabulator<2.0,>=1.3->tableschema->superset) (1.1.0)
Requirement already satisfied: linear-tsv<2.0,>=1.0 in d:\python\lib\site-packages (from tabulator<2.0,>=1.3->tableschema->superset) (1.1.0)
Requirement already satisfied: jsonlines<2.0,>=1.1 in d:\python\lib\site-packages (from tabulator<2.0,>=1.3->tableschema->superset) (1.2.0)
Requirement already satisfied: openpyxl<2.5,>=2.4 in d:\python\lib\site-packages (from tabulator<2.0,>=1.3->tableschema->superset) (2.4.11)
Collecting cchardet<3.0,>=1.0 (from tabulator<2.0,>=1.3->tableschema->superset)
  Downloading https://files.pythonhosted.org/packages/dd/6a/6b54a269caa3518b6eaab3aec0fa4fa9eaa8019b4ae84a7c3ef66b1f9be0/cchardet-2.1.4-cp37-cp37m-win32.whl (89kB)
    100% |████████████████████████████████| 92kB 184kB/s
Requirement already satisfied: ijson<3.0,>=2.0 in d:\python\lib\site-packages (from tabulator<2.0,>=1.3->tableschema->superset) (2.3)
Requirement already satisfied: vine>=1.1.3 in d:\python\lib\site-packages (from amqp<3.0,>=2.1.4->kombu<5.0,>=4.2.0->celery>=4.2.0->superset) (1.1.4)
Requirement already satisfied: defusedxml in d:\python\lib\site-packages (from python3-openid>=2.0->Flask-OpenID<2,>=1.2.5->flask-appbuilder>=1.12.0->superset) (0.5.0)
Requirement already satisfied: jdcal in d:\python\lib\site-packages (from openpyxl<2.5,>=2.4->tabulator<2.0,>=1.3->tableschema->superset) (1.4)
Requirement already satisfied: et-xmlfile in d:\python\lib\site-packages (from openpyxl<2.5,>=2.4->tabulator<2.0,>=1.3->tableschema->superset) (1.0.1)
Installing collected packages: Flask-Login, Flask-SQLAlchemy, flask-appbuilder, markdown, cchardet, tabulator, tableschema, superset
  Found existing installation: Flask-Login 0.2.11
    Uninstalling Flask-Login-0.2.11:
      Successfully uninstalled Flask-Login-0.2.11
  Running setup.py install for Flask-Login ... done
  Found existing installation: Flask-SQLAlchemy 2.1
    Uninstalling Flask-SQLAlchemy-2.1:
      Successfully uninstalled Flask-SQLAlchemy-2.1
  Found existing installation: Flask-AppBuilder 1.10.0
    Uninstalling Flask-AppBuilder-1.10.0:
      Successfully uninstalled Flask-AppBuilder-1.10.0
  Running setup.py install for flask-appbuilder ... done
  Found existing installation: Markdown 2.6.11
    Uninstalling Markdown-2.6.11:
      Successfully uninstalled Markdown-2.6.11
  Running setup.py install for superset ... done
Successfully installed Flask-Login-0.4.1 Flask-SQLAlchemy-2.3.2 cchardet-2.1.4 flask-appbuilder-1.12.1 markdown-3.0.1 superset-0.28.0 tableschema-1.2.5 tabulator-1.17.0
You are using pip version 18.0, however version 18.1 is available.
You should consider upgrading via the 'python -m pip install --upgrade pip' command.

# 创建管理员帐号
fabmanager create-admin --app superset
Username [admin]: xxx
User first name [admin]: xxx
User last name [user]: xxx
Email [admin@fab.org]: xxx@qq.cn
Password:
Repeat for confirmation:
Recognized Database Authentications.
Admin User xxx created.

# 初始化数据库 (windows下,先进入到
Python安装目录(或者virtualEnv的虚拟目录)下,lib\site-packages\superset\bin下)
cd /d/python/lib/site-packages/superset/bin
Python superset db upgrade
INFO  [alembic.runtime.migration] Context impl SQLiteImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL
# 加载例子(后续操作都需要在lib\site-packages\superset\bin下)
Python superset load_examples
2018-10-18 20:36:31,358:INFO:root:Creating database reference
2018-10-18 20:36:31,401:INFO:root:Database.get_sqla_engine(). Masked URL: sqlite:///C:\Users\xxx\.superset\superset.db
2018-10-18 20:36:42,164:INFO:root:Creating database reference
2018-10-18 20:36:44,521:INFO:root:Creating database reference
2018-10-18 20:36:45,654:INFO:root:Creating database reference
2018-10-18 20:37:02,201:INFO:root:Creating database reference
2018-10-18 20:37:02,378:INFO:root:Creating database reference
2018-10-18 20:37:02,547:INFO:root:Creating database reference
2018-10-18 20:37:04,243:INFO:root:Creating database reference
2018-10-18 20:37:04,380:INFO:root:Creating database reference
2018-10-18 20:37:08,631:INFO:root:Creating database reference
2018-10-18 20:37:08,789:INFO:root:Creating database reference
2018-10-18 20:37:19,065:INFO:root:Creating database reference
2018-10-18 20:37:21,217:INFO:root:Creating database reference
Loading examples into <SQLA engine=sqlite:///C:\Users\xxx\.superset\superset.db>
Creating default CSS templates
Loading energy related dataset
Creating table [wb_health_population] reference
Loading [World Bank's Health Nutrition and Population Stats]
Creating table [wb_health_population] reference
Creating slices
Creating a World's Health Bank dashboard
Loading [Birth names]
Done loading table!
--------------------------------------------------------------------------------
Creating table [birth_names] reference
Creating some slices
Creating a dashboard
Loading [Random time series data]
Done loading table!
--------------------------------------------------------------------------------
Creating table [random_time_series] reference
Creating a slice
Loading [Random long/lat data]
Done loading table!
--------------------------------------------------------------------------------
Creating table reference
Creating a slice
Loading [Country Map data]
Done loading table!
--------------------------------------------------------------------------------
Creating table reference
Creating a slice
Loading [Multiformat time series]
Done loading table!
--------------------------------------------------------------------------------
Creating table [multiformat_time_series] reference
Creating Heatmap charts
Loading [Paris GeoJson]
Creating table paris_iris_mapping reference
Loading [San Francisco population polygons]
Creating table sf_population_polygons reference
Loading [Flights data]
Done loading table!
Loading [BART lines]
Creating table bart_lines reference
Loading [Multi Line]
Creating table [wb_health_population] reference
Creating slices
Creating a World's Health Bank dashboard
Done loading table!
--------------------------------------------------------------------------------
Creating table [birth_names] reference
Creating some slices
Creating a dashboard
Loading [Misc Charts] dashboard
Creating the dashboard
Loading DECK.gl demo
Loading deck.gl dashboard
Creating Scatterplot slice
Creating Screen Grid slice
Creating Hex slice
Creating Grid slice
Creating Polygon slice
Creating Arc slice
Creating Path slice
Creating a dashboard

# 初始化角色和权限
Python superset init
2018-10-18 20:38:30,683:INFO:root:Creating database reference
2018-10-18 20:38:30,690:INFO:root:Syncing role definition
2018-10-18 20:38:30,697:INFO:root:Syncing Admin perms
2018-10-18 20:38:30,771:INFO:root:Syncing Alpha perms
2018-10-18 20:38:30,845:INFO:root:Syncing Gamma perms
2018-10-18 20:38:30,919:INFO:root:Syncing granter perms
2018-10-18 20:38:30,993:INFO:root:Syncing sql_lab perms
2018-10-18 20:38:31,072:INFO:root:Fetching a set of all perms to lookup which ones are missing
2018-10-18 20:38:31,174:INFO:root:Creating missing datasource permissions.
2018-10-18 20:38:31,182:INFO:root:Creating missing database permissions.
2018-10-18 20:38:31,184:INFO:root:Creating missing metrics permissions
2018-10-18 20:38:31,216:INFO:root:Cleaning faulty perms
$ python superset runserver
2018-10-18 20:38:48,839:INFO:root:The Gunicorn 'superset runserver' command is deprecated. Please use the 'gunicorn' command instead.
Traceback (most recent call last):
  File "d:\python\lib\runpy.py", line 193, in _run_module_as_main
    "__main__", mod_spec)
  File "d:\python\lib\runpy.py", line 85, in _run_code
    exec(code, run_globals)
  File "D:\python\Scripts\gunicorn.exe\__main__.py", line 5, in <module>
  File "d:\python\lib\site-packages\gunicorn\app\wsgiapp.py", line 9, in <module>
    from gunicorn.app.base import Application
  File "d:\python\lib\site-packages\gunicorn\app\base.py", line 12, in <module>
    from gunicorn import util
  File "d:\python\lib\site-packages\gunicorn\util.py", line 9, in <module>
    import fcntl
ModuleNotFoundError: No module named 'fcntl'
Starting server with command:
gunicorn -w 2 --timeout 60 -b  0.0.0.0:8088 --limit-request-line 0 --limit-request-field_size 0 superset:app
# 启动服务,端口 8088, 使用 -p 更改端口号。
Python superset runserver -d
2018-10-18 20:40:14,223:INFO:werkzeug: * Restarting with stat
2018-10-18 20:40:17,704:WARNING:werkzeug: * Debugger is active!
2018-10-18 20:40:17,720:INFO:werkzeug: * Debugger PIN: 139-127-258
2018-10-18 20:40:17,732:INFO:werkzeug: * Running on http://0.0.0.0:8088/ (Press CTRL+C to quit)

安装MySQL包

λ pip install mysqlclient
Collecting mysqlclient
  Using cached https://files.pythonhosted.org/packages/ec/fd/83329b9d3e14f7344d1cb31f128e6dbba70c5975c9e57896815dbb1988ad/mysqlclient-1.3.13.tar.gz
Installing collected packages: mysqlclient
  Running setup.py install for mysqlclient ... error
    Complete output from command d:\python\python.exe -u -c "import setuptools, tokenize;__file__='C:\\Users\\xxxx\\AppData\\Local\\Temp\\pip-install-wmrhs8m3\\mysqlclient\\setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record C:\Users\xxxx\AppData\Local\Temp\pip-record-z4r5l4fy\install-record.txt --single-version-externally-managed --compile:
    d:\python\lib\distutils\dist.py:274: UserWarning: Unknown distribution option: 'long_description_content_type'
      warnings.warn(msg)
    running install
    running build
    running build_py
    creating build
    creating build\lib.win32-3.7
    copying _mysql_exceptions.py -> build\lib.win32-3.7
    creating build\lib.win32-3.7\MySQLdb
    copying MySQLdb\__init__.py -> build\lib.win32-3.7\MySQLdb
    copying MySQLdb\compat.py -> build\lib.win32-3.7\MySQLdb
    copying MySQLdb\connections.py -> build\lib.win32-3.7\MySQLdb
    copying MySQLdb\converters.py -> build\lib.win32-3.7\MySQLdb
    copying MySQLdb\cursors.py -> build\lib.win32-3.7\MySQLdb
    copying MySQLdb\release.py -> build\lib.win32-3.7\MySQLdb
    copying MySQLdb\times.py -> build\lib.win32-3.7\MySQLdb
    creating build\lib.win32-3.7\MySQLdb\constants
    copying MySQLdb\constants\__init__.py -> build\lib.win32-3.7\MySQLdb\constants
    copying MySQLdb\constants\CLIENT.py -> build\lib.win32-3.7\MySQLdb\constants
    copying MySQLdb\constants\CR.py -> build\lib.win32-3.7\MySQLdb\constants
    copying MySQLdb\constants\ER.py -> build\lib.win32-3.7\MySQLdb\constants
    copying MySQLdb\constants\FIELD_TYPE.py -> build\lib.win32-3.7\MySQLdb\constants
    copying MySQLdb\constants\FLAG.py -> build\lib.win32-3.7\MySQLdb\constants
    copying MySQLdb\constants\REFRESH.py -> build\lib.win32-3.7\MySQLdb\constants
    running build_ext
    building '_mysql' extension
    error: Microsoft Visual C++ 14.0 is required. Get it with "Microsoft Visual C++ Build Tools": http://landinghub.visualstudio.com/visual-cpp-build-tools

    ----------------------------------------
Command "d:\python\python.exe -u -c "import setuptools, tokenize;__file__='C:\\Users\\xxx\\AppData\\Local\\Temp\\pip-install-wmrhs8m3\\mysqlclient\\setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record C:\Users\xxx\AppData\Local\Temp\pip-record-z4r5l4fy\install-record.txt --single-version-externally-managed --compile" failed with error code 1 in C:\Users\xxx\AppData\Local\Temp\pip-install-wmrhs8m3\mysqlclient\

clipboard.png

$ curl https://download.lfd.uci.edu/pythonlibs/h2ufg7oq/mysqlclient-1.3.13-cp37-cp37m-win32.whl -o  mysqlclient-1.3.13-cp37-cp37m-win32.whl
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100 1211k  100 1211k    0     0   2087      0  0:09:54  0:09:54 --:--:-- 26499

$ pip install mysqlclient-1.3.13-cp37-cp37m-win32.whl
Processing d:\code\mysqlclient-1.3.13-cp37-cp37m-win32.whl
Installing collected packages: mysqlclient
Successfully installed mysqlclient-1.3.13

测试连接

clipboard.png

参考

http://timd.cn/superset/
https://www.v2ex.com/amp/t/43...
https://blog.csdn.net/qq_3344...
https://zhuanlan.zhihu.com/p/...
https://www.cnblogs.com/calmz...
https://www.cnblogs.com/calmz...
https://www.jianshu.com/p/b37...
https://stackoverflow.com/que...
https://www.cnblogs.com/shaos...
https://blog.csdn.net/qq27368...
https://www.jianshu.com/p/a6f...
https://github.com/apache/inc...
数据可视化平台superset使用心得
一小时建立数据分析平台

阅读 5.2k

技术分享
PHP,Python 相关
18.9k 声望
1.9k 粉丝
0 条评论
18.9k 声望
1.9k 粉丝
文章目录
宣传栏