資訊專欄INFORMATION COLUMN
摘要：安裝遠(yuǎn)程主機(jī)強(qiáng)迫關(guān)閉了一個(gè)現(xiàn)有的連接。安裝包測(cè)試連接參考數(shù)據(jù)可視化平臺(tái)使用心得一小時(shí)建立數(shù)據(jù)分析平臺(tái)
安裝 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:pythonlibsite-packages (from superset) (2.1.4)
Requirement already satisfied: boto3==1.4.7 in d:pythonlibsite-packages (from superset) (1.4.7)
Requirement already satisfied: botocore<1.8.0,>=1.7.0 in d:pythonlibsite-packages (from superset) (1.7.48)
Requirement already satisfied: celery>=4.2.0 in d:pythonlibsite-packages (from superset) (4.2.1)
Requirement already satisfied: click==6.7 in d:pythonlibsite-packages (from superset) (6.7)
Requirement already satisfied: colorama==0.3.9 in d:pythonlibsite-packages (from superset) (0.3.9)
Requirement already satisfied: contextlib2 in d:pythonlibsite-packages (from superset) (0.5.5)
Requirement already satisfied: cryptography in d:pythonlibsite-packages (from superset) (2.3.1)
Requirement already satisfied: flask<1.0.0 in d:pythonlibsite-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, "遠(yuǎn)程主機(jī)強(qiáng)迫
關(guān)閉了一個(gè)現(xiàn)有的連接。", 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:pythonlibsite-packages (from superset) (1.4.0)
Requirement already satisfied: flask-compress in d:pythonlibsite-packages (from superset) (1.4.0)
Requirement already satisfied: flask-migrate in d:pythonlibsite-packages (from superset) (2.2.1)
Requirement already satisfied: flask-wtf in d:pythonlibsite-packages (from superset) (0.14.2)
Requirement already satisfied: flower in d:pythonlibsite-packages (from superset) (0.9.2)
Requirement already satisfied: future<0.17,>=0.16.0 in d:pythonlibsite-packages (from superset) (0.16.0)
Requirement already satisfied: geopy in d:pythonlibsite-packages (from superset) (1.16.0)
Requirement already satisfied: gunicorn in d:pythonlibsite-packages (from superset) (19.9.0)
Requirement already satisfied: humanize in d:pythonlibsite-packages (from superset) (0.5.1)
Requirement already satisfied: idna in d:pythonlibsite-packages (from superset) (2.7)
Requirement already satisfied: isodate in d:pythonlibsite-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:pythonlibsite-packages (from superset) (0.23.4)
Requirement already satisfied: parsedatetime in d:pythonlibsite-packages (from superset) (2.4)
Requirement already satisfied: pathlib2 in d:pythonlibsite-packages (from superset) (2.3.2)
Requirement already satisfied: polyline in d:pythonlibsite-packages (from superset) (1.3.2)
Requirement already satisfied: pydruid>=0.4.3 in d:pythonlibsite-packages (from superset) (0.4.5)
Requirement already satisfied: pyhive>=0.4.0 in d:pythonlibsite-packages (from superset) (0.6.0)
Requirement already satisfied: python-dateutil in d:pythonlibsite-packages (from superset) (2.7.3)
Requirement already satisfied: python-geohash in d:pythonlibsite-packages (from superset) (0.8.5)
Requirement already satisfied: pyyaml>=3.11 in d:pythonlibsite-packages (from superset) (3.13)
Requirement already satisfied: requests in d:pythonlibsite-packages (from superset) (2.19.1)
Requirement already satisfied: simplejson>=3.15.0 in d:pythonlibsite-packages (from superset) (3.16.0)
Requirement already satisfied: sqlalchemy in d:pythonlibsite-packages (from superset) (1.2.11)
Requirement already satisfied: sqlalchemy-utils in d:pythonlibsite-packages (from superset) (0.33.3)
Requirement already satisfied: sqlparse in d:pythonlibsite-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:pythonlibsite-packages (from superset) (0.11.0)
Requirement already satisfied: thrift-sasl>=0.2.1 in d:pythonlibsite-packages (from superset) (0.3.0)
Requirement already satisfied: unicodecsv in d:pythonlibsite-packages (from superset) (0.14.1)
Requirement already satisfied: unidecode>=0.04.21 in d:pythonlibsite-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:pythonlibsite-packages (from bleach->superset) (1.0.1)
Requirement already satisfied: six in d:pythonlibsite-packages (from bleach->superset) (1.11.0)
Requirement already satisfied: jmespath<1.0.0,>=0.7.1 in d:pythonlibsite-packages (from boto3==1.4.7->superset) (0.9.3)
Requirement already satisfied: s3transfer<0.2.0,>=0.1.10 in d:pythonlibsite-packages (from boto3==1.4.7->superset) (0.1.13)
Requirement already satisfied: docutils>=0.10 in d:pythonlibsite-packages (from botocore<1.8.0,>=1.7.0->superset) (0.14)
Requirement already satisfied: pytz>dev in d:pythonlibsite-packages (from celery>=4.2.0->superset) (2018.5)
Requirement already satisfied: billiard<3.6.0,>=3.5.0.2 in d:pythonlibsite-packages (from celery>=4.2.0->superset) (3.5.0.4)
Requirement already satisfied: kombu<5.0,>=4.2.0 in d:pythonlibsite-packages (from celery>=4.2.0->superset) (4.2.1)
Requirement already satisfied: asn1crypto>=0.21.0 in d:pythonlibsite-packages (from cryptography->superset) (0.24.0)
Requirement already satisfied: cffi!=1.11.3,>=1.7 in d:pythonlibsite-packages (from cryptography->superset) (1.11.5)
Requirement already satisfied: Jinja2>=2.4 in d:pythonlibsite-packages (from flask<1.0.0->superset) (2.10)
Requirement already satisfied: itsdangerous>=0.21 in d:pythonlibsite-packages (from flask<1.0.0->superset) (0.24)
Requirement already satisfied: Werkzeug>=0.7 in d:pythonlibsite-packages (from flask<1.0.0->superset) (0.14.1)
Requirement already satisfied: Flask-Babel<1,>=0.11.1 in d:pythonlibsite-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:pythonlibsite-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:pythonlibsite-packages (from flask-migrate->superset) (1.0.0)
Requirement already satisfied: WTForms in d:pythonlibsite-packages (from flask-wtf->superset) (2.2.1)
Requirement already satisfied: tornado>=4.2.0 in d:pythonlibsite-packages (from flower->superset) (5.1)
Requirement already satisfied: babel>=1.0 in d:pythonlibsite-packages (from flower->superset) (2.6.0)
Requirement already satisfied: geographiclib<2,>=1.49 in d:pythonlibsite-packages (from geopy->superset) (1.49)
Requirement already satisfied: numpy>=1.9.0 in d:pythonlibsite-packages (from pandas>=0.18.0->superset) (1.15.1)
Requirement already satisfied: certifi>=2017.4.17 in d:pythonlibsite-packages (from requests->superset) (2018.8.24)
Requirement already satisfied: chardet<3.1.0,>=3.0.2 in d:pythonlibsite-packages (from requests->superset) (3.0.4)
Requirement already satisfied: urllib3<1.24,>=1.21.1 in d:pythonlibsite-packages (from requests->superset) (1.23)
Requirement already satisfied: jsonschema<3.0,>=2.5 in d:pythonlibsite-packages (from tableschema->superset) (2.6.0)
Requirement already satisfied: rfc3986<2.0,>=1.1.0 in d:pythonlibsite-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:pythonlibsite-packages (from thrift-sasl>=0.2.1->superset) (0.5.1)
Requirement already satisfied: webencodings in d:pythonlibsite-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:pythonlibsite-packages (from kombu<5.0,>=4.2.0->celery>=4.2.0->superset) (2.3.2)
Requirement already satisfied: pycparser in d:pythonlibsite-packages (from cffi!=1.11.3,>=1.7->cryptography->superset) (2.18)
Requirement already satisfied: MarkupSafe>=0.23 in d:pythonlibsite-packages (from Jinja2>=2.4->flask<1.0.0->superset) (1.0)
Requirement already satisfied: python3-openid>=2.0 in d:pythonlibsite-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:pythonlibsite-packages (from alembic>=0.7->flask-migrate->superset) (1.0.3)
Requirement already satisfied: Mako in d:pythonlibsite-packages (from alembic>=0.7->flask-migrate->superset) (1.0.7)
Requirement already satisfied: xlrd<2.0,>=1.0 in d:pythonlibsite-packages (from tabulator<2.0,>=1.3->tableschema->superset) (1.1.0)
Requirement already satisfied: linear-tsv<2.0,>=1.0 in d:pythonlibsite-packages (from tabulator<2.0,>=1.3->tableschema->superset) (1.1.0)
Requirement already satisfied: jsonlines<2.0,>=1.1 in d:pythonlibsite-packages (from tabulator<2.0,>=1.3->tableschema->superset) (1.2.0)
Requirement already satisfied: openpyxl<2.5,>=2.4 in d:pythonlibsite-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:pythonlibsite-packages (from tabulator<2.0,>=1.3->tableschema->superset) (2.3)
Requirement already satisfied: vine>=1.1.3 in d:pythonlibsite-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:pythonlibsite-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:pythonlibsite-packages (from openpyxl<2.5,>=2.4->tabulator<2.0,>=1.3->tableschema->superset) (1.4)
Requirement already satisfied: et-xmlfile in d:pythonlibsite-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.
# 創(chuàng)建管理員帳號(hào)
fabmanager create-admin --app superset
Username [admin]: xxx
User first name [admin]: xxx
User last name [user]: xxx
Email [[email protected]]: [email protected]
Password:
Repeat for confirmation:
Recognized Database Authentications.
Admin User xxx created.
# 初始化數(shù)據(jù)庫 (windows下，先進(jìn)入到
Python安裝目錄（或者virtualEnv的虛擬目錄）下，libsite-packagessupersetin下)
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
# 加載例子(后續(xù)操作都需要在libsite-packagessupersetin下)
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:Usersxxx.supersetsuperset.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
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
# 初始化角色和權(quán)限
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:pythonlib
unpy.py", line 193, in _run_module_as_main
"__main__", mod_spec)
File "d:pythonlib
unpy.py", line 85, in _run_code
exec(code, run_globals)
File "D:pythonScriptsgunicorn.exe\__main__.py", line 5, in
File "d:pythonlibsite-packagesgunicornappwsgiapp.py", line 9, in
from gunicorn.app.base import Application
File "d:pythonlibsite-packagesgunicornappase.py", line 12, in
from gunicorn import util
File "d:pythonlibsite-packagesgunicornutil.py", line 9, in
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
# 啟動(dòng)服務(wù)，端口 8088, 使用 -p 更改端口號(hào)。
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:pythonpython.exe -u -c "import setuptools, tokenize;__file__="C:UsersxxxxAppDataLocalTemppip-install-wmrhs8m3mysqlclientsetup.py";f=getattr(tokenize, "open", open)(__file__);code=f.read().replace("
", "
");f.close();exec(compile(code, __file__, "exec"))" install --record C:UsersxxxxAppDataLocalTemppip-record-z4r5l4fyinstall-record.txt --single-version-externally-managed --compile:
d:pythonlibdistutilsdist.py:274: UserWarning: Unknown distribution option: "long_description_content_type"
warnings.warn(msg)
running install
running build
running build_py
creating build
creating buildlib.win32-3.7
copying _mysql_exceptions.py -> buildlib.win32-3.7
creating buildlib.win32-3.7MySQLdb
copying MySQLdb\__init__.py -> buildlib.win32-3.7MySQLdb
copying MySQLdbcompat.py -> buildlib.win32-3.7MySQLdb
copying MySQLdbconnections.py -> buildlib.win32-3.7MySQLdb
copying MySQLdbconverters.py -> buildlib.win32-3.7MySQLdb
copying MySQLdbcursors.py -> buildlib.win32-3.7MySQLdb
copying MySQLdb
elease.py -> buildlib.win32-3.7MySQLdb
copying MySQLdb imes.py -> buildlib.win32-3.7MySQLdb
creating buildlib.win32-3.7MySQLdbconstants
copying MySQLdbconstants\__init__.py -> buildlib.win32-3.7MySQLdbconstants
copying MySQLdbconstantsCLIENT.py -> buildlib.win32-3.7MySQLdbconstants
copying MySQLdbconstantsCR.py -> buildlib.win32-3.7MySQLdbconstants
copying MySQLdbconstantsER.py -> buildlib.win32-3.7MySQLdbconstants
copying MySQLdbconstantsFIELD_TYPE.py -> buildlib.win32-3.7MySQLdbconstants
copying MySQLdbconstantsFLAG.py -> buildlib.win32-3.7MySQLdbconstants
copying MySQLdbconstantsREFRESH.py -> buildlib.win32-3.7MySQLdbconstants
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:pythonpython.exe -u -c "import setuptools, tokenize;__file__="C:UsersxxxAppDataLocalTemppip-install-wmrhs8m3mysqlclientsetup.py";f=getattr(tokenize, "open", open)(__file__);code=f.read().replace("
", "
");f.close();exec(compile(code, __file__, "exec"))" install --record C:UsersxxxAppDataLocalTemppip-record-z4r5l4fyinstall-record.txt --single-version-externally-managed --compile" failed with error code 1 in C:UsersxxxAppDataLocalTemppip-install-wmrhs8m3mysqlclient
$ 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:codemysqlclient-1.3.13-cp37-cp37m-win32.whl
Installing collected packages: mysqlclient
Successfully installed mysqlclient-1.3.13
測(cè)試連接
參考
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...
數(shù)據(jù)可視化平臺(tái)superset使用心得
一小時(shí)建立數(shù)據(jù)分析平臺(tái)
文章版權(quán)歸作者所有，未經(jīng)允許請(qǐng)勿轉(zhuǎn)載,若此文章存在違規(guī)行為，您可以聯(lián)系管理員刪除。
轉(zhuǎn)載請(qǐng)注明本文地址：http://systransis.cn/yun/44921.html
摘要：概述我非常認(rèn)同前百度數(shù)據(jù)工程師現(xiàn)神策分析創(chuàng)始人桑老師最近談到的數(shù)據(jù)分析三重境界統(tǒng)計(jì)計(jì)數(shù)多維分析機(jī)器學(xué)習(xí)數(shù)據(jù)分析的統(tǒng)計(jì)計(jì)數(shù)和多維分析，我們通常稱之為數(shù)據(jù)探索式分析，這個(gè)步驟旨在了解數(shù)據(jù)的特性，有助于我們進(jìn)一步挖掘數(shù)據(jù)的價(jià)值。 showImg(https://camo.githubusercontent.com/f98421e503a81176b003ddd310d97e1e1214625...
摘要：請(qǐng)?jiān)徫乙韵滤薪貓D中都是使用的中文，有些地方翻譯略顯生硬。本來系統(tǒng)是使用的英文，奈何領(lǐng)導(dǎo)要求中文呀。時(shí)間字段的表示時(shí)間屬性必須勾選上一般會(huì)時(shí)間列默認(rèn)勾選。可根據(jù)來排查問題所在，并且系統(tǒng)為用戶提供版的查詢工具來操作數(shù)據(jù)庫。Superset簡(jiǎn)介 Superset是一個(gè)受Apache軟件基金會(huì)支持的處于孵化階段的企業(yè)級(jí)數(shù)據(jù)可視化web項(xiàng)目。具有以下特點(diǎn)： 內(nèi)含豐富的數(shù)據(jù)圖表樣式 支持多種數(shù)據(jù)源...
摘要：通過數(shù)據(jù)分析和挖掘，讓數(shù)據(jù)產(chǎn)生價(jià)值。數(shù)據(jù)可視化是大數(shù)據(jù)的最后一公里，做好可視化是對(duì)于數(shù)據(jù)分析是重要的。今天，主要介紹這款數(shù)據(jù)分析的利器。相比除了上手簡(jiǎn)單，支持等時(shí)序數(shù)據(jù)庫。這點(diǎn)對(duì)于監(jiān)控?cái)?shù)據(jù)分析很有優(yōu)勢(shì)。數(shù)據(jù)源包括時(shí)序數(shù)據(jù)庫，和業(yè)務(wù)庫。 前言 在之前文章中，一直講prometheus的metrics以及apm的指標(biāo)的重要性，多側(cè)重于收據(jù)的收集和存儲(chǔ)。如果不對(duì)這些數(shù)據(jù)進(jìn)行數(shù)據(jù)分析，那么就沒...
閱讀 1927·2021-11-22 09:34
閱讀 1158·2021-10-09 09:44
閱讀 3051·2021-09-29 09:35
閱讀 3628·2021-09-14 18:01
閱讀 1497·2021-08-16 10:49
閱讀 1097·2019-08-29 14:11
閱讀 861·2019-08-29 12:47
閱讀 3082·2019-08-26 13:47
