集成Apache Superset和Apache Drill [英] Integrating Apache Superset and Apache Drill

问题描述

我通过 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

我在这里报告了此问题 https://github.com/amancevice/docker-superset/issues/158 也许会在即将发布的图片中得到解决.

I have reported this issue here https://github.com/amancevice/docker-superset/issues/158 maybe it get fixed with the upcoming images.

这篇关于集成Apache Superset和Apache Drill的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！