安装使用 superset
安装 superset
创建虚拟环境:
python -m venv msuperset
激活虚拟环境:
cd msuperset
source bin/activate
安装 superset
pip install superset
如果遇到报错:
Running setup.py install for python-geohash ... error
Complete output from command /root/code/python/msuperset/bin/python -u -c "import setuptools, tokenize;__file__='/tmp/pip-build-szdbf0qe/python-geohash/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record /tmp/pip-omybv2pz-record/install-record.txt --single-version-externally-managed --compile --install-headers /root/code/python/msuperset/include/site/python3.6/python-geohash:
running install
running build
running build_py
creating build
creating build/lib.linux-x86_64-3.6
copying geohash.py -> build/lib.linux-x86_64-3.6
copying quadtree.py -> build/lib.linux-x86_64-3.6
copying jpgrid.py -> build/lib.linux-x86_64-3.6
copying jpiarea.py -> build/lib.linux-x86_64-3.6
running build_ext
building '_geohash' extension
creating build/temp.linux-x86_64-3.6
creating build/temp.linux-x86_64-3.6/src
gcc -pthread -B /root/miniconda3/compiler_compat -Wl,--sysroot=/ -Wsign-compare -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -fPIC -DPYTHON_MODULE=1 -I/root/code/python/msuperset/include -I/root/miniconda3/include/python3.6m -c src/geohash.cpp -o build/temp.linux-x86_64-3.6/src/geohash.o
gcc: error trying to exec 'cc1plus': execvp: No such file or directory
error: command 'gcc' failed with exit status 1
----------------------------------------
Command "/root/code/python/msuperset/bin/python -u -c "import setuptools, tokenize;__file__='/tmp/pip-build-szdbf0qe/python-geohash/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record /tmp/pip-omybv2pz-record/install-record.txt --single-version-externally-managed --compile --install-headers /root/code/python/msuperset/include/site/python3.6/python-geohash" failed with error code 1 in /tmp/pip-build-szdbf0qe/python-geohash/
需要安装 gcc-c++
:
yum install gcc-c++
装完 gcc-c++
后,再执行 pip install superset
应该就没问题了。
配置 superset
创建管理员用户
fabmanager create-admin --app superset
执行的时候会有这么一行提示:
fabmanager is going to be deprecated in 2.2.X, you can use the same commands on the improved 'flask fab <command>'
这是一个新的用法了,还没有研究
接着会让你输入用户名(username)、Fist Name、Last Name、邮箱地址、密码、重复密码。
如果遇到以下错误:
Was unable to import superset Error: cannot import name '_maybe_box_datetimelike'
原因是 pandas
(在安装 superset
时会做为依赖被安装上)版本太高,需要卸载,再安装低版本的 pandas
。
pip install pandas==0.23.4
参考https://blog.csdn.net/kongxx/article/details/89006787
然后重新执行创建管理员用户的命令:
fabmanager create-admin --app superset
初始化数据库
superset db upgrade
如果遇到错误:
...
File "/root/code/python/msuperset/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2572, in _join_determine_implicit_left_side
"Can't determine which FROM clause to join "
sqlalchemy.exc.InvalidRequestError: Can't determine which FROM clause to join from, there are multiple FROMS which can join to this entity. Try adding an explicit ON clause to help resolve the ambiguity.
说明 sqlalchemy
版本太高了,要降级 sqlalchemy
:
pip install sqlalchemy==1.2.18
参考https://github.com/apache/incubator-superset/issues/6977
载入测试数据
superset load_examples
初始化角色和权限
superset init
启动服务
端口号 8088,使用 -p 更改端口号
superset runserver
然后在浏览器中打开 http://localhsot:8088 就可以看到 superset 了
添加 mysql 数据源时出错
提示
ModuleNotFoundError: No module named 'MySQLdb'
因为 MySQLdb 是 python2 的产品。可使用 mysqlclient 方式代替。要安装 mysqlclient
:
先安装需要用到的系统依赖:
Ubuntu
下:
sudo apt-get install python3-dev libmysqlclient-dev
CentOS
下:
yum install python-devel mysql-devel
然后安装 mysqlclient
:
pip install mysqlclient
其它错误
...
In file included from sasl/saslwrapper.cpp:254:0:
sasl/saslwrapper.h:22:10: fatal error: sasl/sasl.h: No such file or directory
#include <sasl/sasl.h>
^~~~~~~~~~~~~
compilation terminated.
error: command 'x86_64-linux-gnu-gcc' failed with exit status 1
安装 libsasl2-dev
ubuntu
apt-get install libsasl2-dev
centos
yum -y install cyrus-sasl cyrus-sasl-devel cyrus-sasl-lib
其它操作参考:
轻量级BI工具Superset的搭建与使用
官方安装说明
(本文完)
--------------------------------------------------------------------------------------------------------------------------
致虚极,守静笃
使用我的阿里云幸运券,购买阿里云ECS有优惠:阿里云幸运券
>>>>> 腾讯云新用户优惠 <<<<<
--------------------------------------------------------------------------------------------------------------------------
致虚极,守静笃
使用我的阿里云幸运券,购买阿里云ECS有优惠:阿里云幸运券
>>>>> 腾讯云新用户优惠 <<<<<