Superset安装步骤

步骤

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://

问题

2.终端最后显示：“段错误 (核心已转储) ”

ulimit -s  102400

将栈的大小改为100M