Superset部署

一、准备安装环境

yum -y install zlib-devel bzip2-devel openssl-devel ncurses-devel sqlite-devel readline-devel tk-devel gdbm-devel db4-devel libpcap-devel xz-devel
yum install -y gcc

二、安装py环境

cd /usr/local/src
tar -xf Python-3.6.6.tgz #解压缩
cd Python-3.6.6 #进⼊python ⽂件夹
./configure #配置
make && make install #安装

三、安装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 libsasl2-devel openldap-devel #安装依赖包

四、安装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

五、在env中安装superset

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-host
pypi.douban.com #升级setuptools
pip3 install superset -i http://pypi.douban.com/simple --trusted-host pypi.douban.
com #安装superset

六.安装superset数据库包

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

七.配置superset

vi superset-py3/lib/python3.6/site-packages/superset/config.py
修改superset配置⽂件，将默认的sqlite3数据库改为MySQL找到:
SQLALCHEMY_DATABASE_URI = ‘mysql://root:lenovo@pxj31/superset?charset=utf8’
八.mysql创建superset数据库
CREATE DATABASE superset /*!40100 DEFAULT CHARACTER SET utf8 */;
九.初始化
fabmanager create-admin --app superset
pxj
lenovo
Username [admin]: pxj
User first name [admin]: pxj
User last name [user]: pxj
Email [admin@fab.org]: aa^HH^H
Password:
Repeat for confirmation:
Repeat for confirmation:
2020-01-05 16:07:10,202:INFO:root:Configured event logger of type <class ‘superset.utils.log.DBEventLogger’>
Recognized Database Authentications.
Admin User pxj created.

superset db upgrade
superset init #初始化superset数据库

mysql:
alter table superset.table_columns modify type varchar(255);
启动：

(superset-py3) [root@pxj31 /usr/local/src]#nohup superset run -h pxj31 -p 8889 &
[1] 43858
(superset-py3) [root@pxj31 /usr/local/src]#nohup: 忽略输入并把输出追加到"nohup.out"

(superset-py3) [root@pxj31 /usr/local/src]#