Shulou(Shulou.com)06/02 Report--

Superset is a lightweight self-service BI framework characterized by an elegant interface and dynamically generating data from data tables.

I. Environment

Windows 10 64-bit Python 3.7

Second, installation steps

Install Python

It is recommended to install Python 3.7.The official website of Python: https://www.python.org/downloads/release/python-373/

Download 64-bit Python download python-3.7.3-amd64.exe, directly use the exe installation package, select to add to the environment variable during the installation process.

Install VS2015

Some of the dependent libraries in Superset need to be compiled using microsoft visual C++ 2010.

Install Visual C++ 2015 Build Tools: http://xiazai.jb51.net/201912/yuanma/VisualBuild_Tools.rar directly

Install superset

Enter the dos interface by cmd first

(1) pip install virtualenv

Use virtualenv to create a working directory on disk D, for example: d:\ vir_env

Enter the following command in CMD:

D:cd D:\ vir_envvirtualenv env

Activate the environment: env\ Scripts\ activate

(2) download and install sasl according to the python version. Download address: http://www.lfd.uci.edu/~gohlke/pythonlibs/#sasl

Choose the appropriate version to download. For example, if the installed python is 3.7and the system is 64-bit, download sasl-0.2.1-cp37-cp37m-win_amd64.whl.

Be sure to pay attention to the version alignment here, otherwise the installation will not be successful and an error will be reported (sasl.h cannot be found).

Copy it to the D:\ vir_env path to execute the command

Pip install sasl-0.2.1-cp37-cp37m-win_amd64.whl

(3) install superset

Pip install superset

Possible problems 1:

Solution:

a. Find the corresponding package in https://www.lfd.uci.edu/~gohlke/pythonlibs/. To match the py version and system version, download it to the D:\ vir_env directory.

b. Install the corresponding whl file

Pip install file name

Possible problems 2:

Error: could not create 'build\ bdist.win-amd64\ wheel.\ superset\ static\ assets\ dist\ vendors-deckgl\ layers\ arc-deckgl\ layers\ geojson-deckgl\ layers\ grid-deckgl\ layers\ hex-deckgl\ layers\ 39b91eb9.81565bc93ff56be4e334.chunk.jsgiving: No such file or directory-- ERROR: Failed building wheel for superset

Solution:

Enable long path support in Windows systems:

Open Registry Editor: regedit

Find the following path: HKEY_LOCAL_MACHINE\ SYSTEM\ CurrentControlSet\ Control\ FileSytem

Find the following key value: LongPathsEnabled

Change the value to 1: the default is 0 and is not enabled.

(4) create an administrator account

Fabmanager create-admin-app superset

Possible problem: error Was unable to import superset Error: cannot import name'_ maybe_box_datetimelike'

Due to the high version of the pandas library, a lower version of the pandas library needs to be installed.

Solution:

A. Pip uninstall pandas

B. Pip install pandas==0.23.4

Created successfully

(5) set up the working directory

Cd D:\ vir_env\ env\ Lib\ site-packages\ superset\ bin

(6) initialize the database

Python superset db upgrade

Problems that may be encountered

InvalidRequestError: Can't determine which FROM clause to join from, there are multiple FROMS which can join to this entity. Try adding an explicit ON clause to help resolve the ambiguity. An error is reported. Png

Solution:

This is due to the high version of the SQLAlchemy library, and a lower version of the SQLAlchemy library needs to be installed.

Pip uninstall SQLAlchemypip install SQLAlchemy==1.3.5

Rerun after that

Python superset db upgrade

(7) load test examples

Python superset load_examples

Possible problems 1:

ConnectionRefusedError: [WinError 10061] unable to connect because the target computer actively refused.

Solution: open the Network and sharing Center, click the Internet option, select the LAN settings in the connection, check the automatic detection settings, and then make sure

Possible problems 2:

It may fail due to the influence of the network condition. Just try to switch the network a few times.

(8) initialize roles and permissions

Python superset init

(9) enable services

Python superset runserver-d

Possible problems:

Error: No such command "runserver".

Solution:

Start using the following command:

Python superset run-p 8088

(10) Open http://localhost:8088 and log in with the previously set user name and password

Summary

The above is the steps of installing superset under the win10 system introduced by the editor. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply you in time. Thank you very much for your support to the website! If you think this article is helpful to you, you are welcome to reprint it, please indicate the source, thank you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.