Superset 部署使用

Superset 安装

Superset 官网部署链接：http://superset.apache.org/installation.html

注意: 使⽤root⽤户操作

1.安装Python3环境准备的包

1 2	yum -y install zlib-devel bzip2-devel openssl-devel ncurses-devel sqlite-devel rea dline-devel tk-devel gdbm-devel db4-devel libpcap-devel xz-devel

2.安装Python3环境

cd /usr/local/src #进⼊源码⽂件夹
wget www.python.org/ftp/python/3.6.6/Python-3.6.6.tgz #下载python⽂件
tar -xf Python-3.6.6.tgz #解压缩
cd Python-3.6.6 #进⼊python ⽂件夹
./configure #配置
make && make install #安装

3.安装EPEL源并安装superset必备的包

yum install epel-release #安装epel源
yum install mysql-devel #安装MySQL开发包，属于pymysqlclient依赖
yum install gcc gcc-c++ libffi-devel python-devel python-wheel openssl-devel libsa
sl2-devel openldap-devel #安装依赖包

4.安装python3的virtualenv并建⽴superset的env

pip3 install virtualenv -i http://pypi.douban.com/simple --trusted-host pypi.douban.com #安装virtualenv
cd /usr/local/src
python3 -m venv superset-py3 #建⽴superset的venv
source superset-py3/bin/activate #激活superset的venv

5.在env中安装superset

1
2
3

pip3 install --upgrade pip -i http://pypi.douban.com/simple --trusted-host pypi.douban.com #升级pip
pip3 install --upgrade setuptools -i http://pypi.douban.com/simple --trusted- hostpypi.douban.com #升级setuptools
pip3 install superset -i http://pypi.douban.com/simple --trusted-host pypi.douban.com #安装superset

6.安装superset数据库包

1
2
3

pip3 install mysqlclient -i http://pypi.douban.com/simple --trusted-host pypi.doub
an.com #安装mysql连接包
pip3 install "pymssql<3.0" -i http://pypi.douban.com/simple --trusted-host pypi.douban.com #安装mssql连接包

7.配置superset

1
2
3

vi superset-py3/lib/python3.6/site-packages/superset/config.py
修改superset配置⽂件，将默认的sqlite3数据库改为MySQL找到:
SQLALCHEMY_DATABASE_URI = 'mysql://root:xxxxxx@bigdata001/superset?charset=utf8'

8.mysql创建superset数据库

1	CREATE DATABASE `superset` /!40100 DEFAULT CHARACTER SET utf8 /;

9.初始化

fabmanager create-admin --app superset #建⽴管理员账号 jackson，密码jackson
superset db upgrade
superset init #初始化superset数据库
mysql> alter table superset.table_columns modify type varchar(255);