ç¯å¢
- centos 6.5
- anaconda 3
- superset 0.30
- MySQL 5.7.26
åè§: anaconda å®è£ åç®å使ç¨
å®è£
//# å建,æ¿æ´»èæç¯å¢
$ conda create --name py3.6 python=3.6
$ source activate py3.6
//# supersetå®è£
$ pip install pandas==0.23.4
$ pip install Flask==1.0.0
$ pip install --upgrade Werkzeug
$ pip install --upgrade six
$ pip install SQLAlchemy==1.2.18
$ pip install superset
å æ°æ®åºä¿®æ¹ä¸ºMySQL
é»è®¤ä½¿ç¨sqlite,æ°æ®åºè·¯å¾ä¸º
~/.superset/superset.db
å¨MySQLé建好æ°æ®åºåç¨æ·åå¯ç ,å¦:superset
MySQL5.6ä¸,supersetåå§åä¼æ¥é,建议使ç¨MySQL5.7以ä¸
Index column size too large. The maximum column size is 767 bytes
å¦æåªè½ä½¿ç¨MySQL5.6,å°±å¨MySQL5.7åå§åå,导åºä¸ºSQL并修æ¹
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
ç¶åå¯¼å ¥MySQL5.6,åæ¶ä¿®æ¹my.cnf,æ·»å
innodb_large_prefix=1
innodb_file_format=barracuda
å®è£ MySQLdb
//# ä¾èµå
$ yum install mysql mysql-devel mysql-libs
//# å®è£
MySQLdb
$ pip install mysqlclient
ä¿®æ¹config.py
$ cd /usr/local/anaconda3/envs/py3.6/lib/python3.6/site-packages/superset
$ vi config.py
#SQLALCHEMY_DATABASE_URI = "sqlite:///" + os.path.join(DATA_DIR, "superset.db")
//# ç¼ç åå建æ°æ®åºæ¶å®ä¹çç¼ç ä¸è´
SQLALCHEMY_DATABASE_URI = 'mysql://superset:[email protected]:PORT/superset?charset=utf8mb4'
åå§åsuperset
//# åå§åæ°æ®åº
$ superset db upgrade
//# å è½½æµè¯æ°æ®
$ superset load_examples
//# å建é»è®¤çè§è²åæé
$ superset init
//# å建ç»å½ç¨æ·
$ flask fab create-admin --app superset
//# å¯å¨å¼åç¯å¢
$ superset run -h 0.0.0.0 -p 8080 --with-threads --reload --debugger
ç产ç¯å¢,åè§superset 以gunicornå¯å¨,并å 为系ç»æå¡
å®è£ å®æå,å¯ä»¥ç»å½webçé¢äº
http://IP:8088
;