Superset安装步骤

最新推荐文章于 2025-12-19 17:26:00 发布

原创最新推荐文章于 2025-12-19 17:26:00 发布 · 393 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

其他

这篇博客介绍了如何在Linux环境中安装Apache Superset，包括安装依赖、创建管理员用户、初始化数据库、加载示例数据和启动服务。特别提到了在连接MySQL数据库时需要指定charset=utf8以避免中文乱码问题。此外，还列出了支持的各种数据库类型及其连接URI。

步骤

1.依赖

sudo apt-get install build-essential libssl-dev libffi-dev python3-dev python3-pip libsasl2-dev libldap2-dev

在这里插入图片描述

pip3 -H  install virtualenv

2.安装

pip3 -H install superset -i https://pypi.douban.com/simple

3.启动

# Install superset
pip install superset

# Create an admin user (you will be prompted to set a username, first and last name before setting a password)
fabmanager create-admin --app superset

# Initialize the database
superset db upgrade

# Load some data to play with
superset load_examples

# Create default roles and permissions
superset init

# To start a development web server on port 8088, use -p to bind to another port
superset runserver -d

4.支持mysql

sudo apt-get install libmysqlclient-dev
sudo -H pip3 install mysqlclient

mysql://用户名:密码@ip/数据库名?charset=utf8

这里注意下，连接需要加上?charset=utf8，否者查询出来中文会是乱码。

database	pypi package	SQLAlchemy URI prefix
MySQL	pip install mysqlclient	mysql://
Postgres	pip install psycopg2	postgresql+psycopg2://
Presto	pip install pyhive	presto://
Hive	pip install pyhive	hive://
Oracle	pip install cx_Oracle	oracle://
sqlite		sqlite://
Snowflake	pip install snowflake-sqlalchemy	snowflake://
Redshift	pip install sqlalchemy-redshift	redshift+psycopg2://
MSSQL	pip install pymssql	mssql://
Impala	pip install impyla	impala://
SparkSQL	pip install pyhive	jdbc+hive://
Greenplum	pip install psycopg2	postgresql+psycopg2://
Athena	pip install “PyAthenaJDBC>1.0.9”	awsathena+jdbc://
Athena	pip install “PyAthena>1.2.0”	awsathena+rest://
Vertica	pip install sqlalchemy-vertica-python	vertica+vertica_python://
ClickHouse	pip install sqlalchemy-clickhouse	clickhouse://
Kylin	pip install kylinpy	kylin://
BigQuery	pip install pybigquery	bigquery://
Teradata	pip install sqlalchemy-teradata	teradata://