superset安装总结

接着上一篇的安装过程，一把辛酸诶。
这个superset在windows系统上安装并不友好，，网上的大部分安装都是老版本的，，现在的版本0.34的使用flask启动。
我觉得使用豆瓣镜像直接安装，然后再配套使用相应的包，，结合这个GitHub上的window10的安装。。应该会成功的吧。。安装软件成功 了， 还只是第一步，接下来。。。。后面遇到坑了，，我再说吧。。
https://gist.github.com/mark05e/d9cccae129dd11a21d7219eddd7d9923

对了，如果你对superset，Python做可视化有很大的兴趣，这里有个QQ群：895772133 欢迎大家加入学习交流。。我也是网上搜索看的QQ群号，，里面有学习资料。。下面的安装文档，也是群里大佬免费提供的，，，谢谢。。

附：我是按照这个安装的，，大家可以自行参考

windows server 2008 R2 + 3.7环境下superset安装过程实战（环境/编译/发布/运行）

感谢以下博主贡献
https://www.jianshu.com/p/c751278996f8

https://blog.csdn.net/gz15126051420/article/details/78258620

https://blog.csdn.net/draven1122/article/details/78342228

https://www.cnblogs.com/Jonecmnn/p/7417498.html

安装过程:

#安装Microsoft Visual C++ Build Tools
https://pan.baidu.com/s/16jVqbrHALNyammOoGKuJjQ
提取码：u2v6
#安装MSVC v140 -VS 2015 C++ 生成工具(v14.00)


#下载源代码
git clone https://github.com/apache/incubator-superset.git


https://nodejs.org/en/download/(下载安装node.js)
https://yarnpkg.com/zh-Hans/docs/install (下载安装yarn,依赖node.js)


#安装环境
pip install -r C:\Users\Administrator\Desktop\request-list.txt -i https://pypi.tuna.tsinghua.edu.cn/simple/

#request-list.txt内容
virtualenv
backoff
bleach
click
celery
colorama
contextlib2
croniter
cryptography
flask
flask-appbuilder
flask-caching
flask-compress
flask-talisman
flask-wtf
flask-migrate
gunicorn
geohash
geopy
humanize
isodate
markdown
msgpack
polyline
prison
pandas
parsedatetime
pathlib2
pyarrow
pyyaml
python-geohash
python-dotenv
sasl
simplejson
urllib3
walk

#从https://www.lfd.uci.edu/~gohlke/pythonlibs/#lxml下载sasl-0.2.1-cp37-cp37m-win_amd64.whl
pip install "C:\Users\Administrator\Downloads\sasl-0.2.1-cp37-cp37m-win_amd64.whl"


cd  incubator-superset

#创建环境
virtualenv venv

venv\Scripts\activate  (ps:C:\Users\Administrator\incubator-superset\venv\Scripts\activate.bat)

cd superset/assets





将C:\Program Files (x86)\Yarn拷贝到C:\Users\Administrator\AppData\Local\Programs\Yarn\bin
(安装后PATH的默认参数C:\Users\Administrator\AppData\Local\Yarn\bin,
修改为C:\Users\Administrator\AppData\Local\Programs\Yarn\bin)


#编译
yarn

yarn run build

cd ../../

#编译(编译之后的效果同 pip install superset )
python setup.py install


#手动在"C:\\Users\\Administrator\\incubator-superset\\superset\\static\\assets\\"下创建空白文件version_info.json


flask fab create-admin

(venv) C:\Users\Administrator\incubator-superset>flask fab create-admin
Username [admin]: admin
User first name [admin]: ye
User last name [user]: yang
Email [admin@fab.org]: 81436962@qq.com
Password:111
Repeat for confirmation:111
INFO:root:logging was configured successfully
Recognized Database Authentications.
Admin User admin created.


flask fab create-permissions

(venv) C:\Users\Administrator\incubator-superset>flask fab create-permissions
INFO:root:logging was configured successfully
Created all permissions

flask fab create-db

(venv) C:\Users\Administrator\incubator-superset>flask fab create-db
INFO:root:logging was configured successfully
DB objects created


cd superset/bin

python superset db upgrade

python superset load_examples

python superset load_test_users

python superset init


flask run

(venv) C:\Users\Administrator\incubator-superset>flask run
 * Serving Flask app "superset.app:create_app()" (lazy loading)
 * Environment: development
 * Debug mode: on
 * Restarting with stat
INFO:root:logging was configured successfully
 * Debugger is active!
 * Debugger PIN: 167-347-427
 * Running on http://127.0.0.1:5000/ (Press CTRL+C to quit)
INFO:root:logging was configured successfully

#登陆进去首页空白

pip install superset

#默认安装到 Python\Lib\site-packages\superset\static
#拷贝 C:\Users\Administrator\AppData\Local\Programs\Python\Python37\Lib\site-packages\superset\static到C:\Users\Administrator\incubator-superset\superset\static

完成