我通过 Drill文档中的链接安装了Apache Drill.>.Apache Drill工作正常.我还安装了Apache Superset并使其使用docker运行.超级集也可以很好地工作.
I installed Apache Drill through the link in the Drill Documentation. Apache Drill works fine. I also installed and got Apache Superset running using docker. Superset also works totally fine.
但是我的目标是将Superset和Drill集成在一起.我唯一能找到的教程是 Dataist教程.遵循本教程时,他们会要求我们添加数据库.
But my goal is to integrate Superset and Drill together. The only tutorial I was able to find was a tutorial from Dataist. When following this tutorial they ask us to add a database.
由于我在本地计算机上同时运行了Drill和Superset,因此他们要求我们键入rill + sadrill://localhost:8047/dfs/test?use_ssl = False作为SQLAlchemy URI.他们要求我们按测试连接来测试连接.
Since I am running both Drill and Superset in my local machine they ask us to type drill+sadrill://localhost:8047/dfs/test?use_ssl=False as the SQLAlchemy URI. They ask us to test the connection by pressing test connection.
按测试连接时,出现如下错误消息.
When pressing test connection I get an error message as follows.
错误:{错误":连接失败!\ n \ n返回的错误消息是:\ n无法加载插件:sqlalchemy.dialects:drill.sadrill","stacktrace":追踪(大多数最近一次通话结束):\ n testconn中的文件\"/home/superset/superset/views/core.py \",行1755 \ n engine = database.get_sqla_engine(user_name = username)\ n文件\"/home/superset/superset/utils/core.py \,第132行,位于__call __ \ n中= self.func(* args,** kwargs)\ n File \"/home/superset/superset/models/core.py \,在get_sqla_engine中的第911行\ n返回create_engine(url,** params)\ n文件\"/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/__ init __.py \,第435行,在create_engine \ n返回策略中.create(* args,** kwargs)\ n文件\"/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py \",第61行,在create \ n入口点= u._get_entrypoint()\ n文件_get_entrypoint中的文件"/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/url.py \"中的行172 \ n cls =Registry.load(name)\ n文件\"/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py \,第240行,位于load \ n \"无法加载插件:%s:%s \%(自组,名称)\ nsqlalchemy.exc.NoSuchModuleError:无法加载插件:sqlalchemy.dialects:drill.sadrill \ n}
有人可以弄清楚为什么我会收到此错误.另外,如果还有其他教程可以使您更好地了解如何设置Drill和超集,那么就可以了.
Can someone figure out why I am getting this error. And also if there are any other tutorials to follow which give a better idea on how to set up Drill and superset.
推荐答案在尝试连接elasticsearch时遇到了类似的问题.我猜您使用的docker映像是amancevice/superset.造成此问题的原因是,您的映像未使用最新的SQLAlchemy,SQLAlchemy-Utils程序包.升级或重新安装这些软件包以解决该问题.
I have encountered a similar issue while trying to connect elasticsearch. I guess the docker image you used was amancevice/superset. This issue cause because your image is not using the latest SQLAlchemy, SQLAlchemy-Utils packages. Upgrade or reinstall these packages to fix the issue.
要卸载:
pip卸载SQLAlchemypip卸载SQLAlchemy-Utils
pip uninstall SQLAlchemy pip uninstall SQLAlchemy-Utils
要重新安装(最新版本):
To install again (latest version):
pip安装SQLAlchemypip安装SQLAlchemy-Utils
pip install SQLAlchemy pip install SQLAlchemy-Utils
我在这里报告了此问题 github/amancevice/docker-superset/issues/158 也许会在即将发布的图片中得到解决.
I have reported this issue here github/amancevice/docker-superset/issues/158 maybe it get fixed with the upcoming images.
更多推荐
集成Apache Superset和Apache Drill
发布评论