Apache Superset is an open source “modern enterprise BI (business intelligence) Web application” from Airbnb that provides lightweight data query and visualization solutions for data analysis by creating and sharing dashboards.

With the recent release of the new version 1.2.0, this tutorial will cover the use of Apache Superset from scratch.

For those who do not want to download it from the official website, the installation files used in this paper are concerned about the flow of big data and can be downloaded by replying superset20210712 in the background.

Apache Superset Installation (Windows)

Windows superset installation is very simple, since the latest version has been added to the PIP library, we can easily install superset using the PIP library.

Install the Python environment

We used Anaconda to quickly install python environments.

Anaconda refers to an open source Distribution of Python that contains a large number of science packages. It also provides many useful tools and is very user-friendly to install.

Latest installation package download address

www.anaconda.com/products/in…

You can download installation packages of various versions through the following addresses.

repo.anaconda.com/archive/

We just need to download the Windows version. Install this exe file after downloading.

Remember to check add environment variables during installation

Now that the Python environment is ready, go to the CMD command line and enter the command to verify

python -V

Python 3.8.3

Install Apache Superset

1 Update the PIP library

First update the PIP library

pip install --upgrade pip
Copy the code

After the update is complete, check out the apache-Superset version of the library

pip install apache-superset==
Copy the code

As you can see, the latest version is 1.2.0

2 install the apache – superset

pip install --upgrade apache-superset
Copy the code

It will take a while for the dependency packages to be installed. Make sure everything is installed and fixed if there are problems.

3 configure apache – superset

Superset db upgradeCopy the code

Success!

# create user superset fab create-adminCopy the code

Set the user name and password in sequence

Superset load_examples superset initCopy the code

4 start

Start the superset with the following command

superset run -p 8088 --with-threads --reload --debugger
Copy the code

Use the preset user name and password to log in

Brand new page. Experience it.

This article explains in detail the installation process of Apache Superset version 1.2.0 (Windows version), next we will carry out the specific operation and practice of Superset.

For more superset articles, check out big data flows

Again, if you don’t want to download various packages from the official website, please pay attention to the flow of big data and reply superset20210712 in the background to download.

Appendix Tread pit record

Pyyaml failed to be installed

★ Uninstall: Pyyaml Found Existing installation: Pyyaml 5.3.1

ERROR: Cannot uninstall ‘PyYAML’. It is a distutils installed project and thus we cannot accurately determine which files belong to it which would lead to only a partial uninstall.

Install using the following instructions

pip install pyyaml --ignore-installed PyYAML
Copy the code

Error 2: Failed to install python-geoHash

Error: Microsoft Visual C++ 14.0 is required. Get it with “Build Tools for Visual Studio”: visualstudio.microsoft.com/downloads/

ERROR: Failed building wheel for python-geohash

Microsoft Visual C++ 14.0 (Visual C++ 14.0

3. Load_examples fails

Ask me this question in private

4. A permission error occurs when you enter the page

Superset init is not executed

This article is published by OpenWrite!