将 Tableau 连接到 Apache Druid [英] Connecting Tableau to Apache Druid

问题描述

谁能告诉我使用 Tableau 连接到 Apache Druid 的步骤吗?

我尝试了

我注意到，如果您将 http 路径指定为gateway/default/hive"，它只会连接到 hive 表.但是，如果您将其更改为网关/默认/llap"这是 HiveServer2(支持 LLAP 的交互式 Hive 服务器)的设置，然后您也可以访问 Apache Druid 表.

请注意，与您提到的文章中的对话框相比，此版本的 Tableau 中的 Tableau 连接对话框略有不同.

如果您尝试通过 Knox 网关进行连接，这应该会有所帮助.

另请注意，Druid 在 Hortonworks 发行版 - HDP 中与 Hive 集成.此设置在此群集上起作用.

Can anybody let me know the steps to connect to Apache Druid using Tableau, please?

I tried the steps shown in this link. But it didn't work.

Thanks

解决方案

I too tried using the Hortonworks Hadoop Hive - way of connecting to Apache Druid from Tableau 2020.3

Since our Druid was on an HDP cluster behind a Knox Gateway, what worked for me was the following settings:

What I noticed is that if you give the http path as "gateway/default/hive", it connects only to hive tables. However if you change that to "gateway/default/llap" which is the setting for HiveServer2 (interactive Hive Server that supports LLAP), then you are able to access of the Apache Druid tables too.

Note that the Tableau Connection Dialog box is slightly different in this version of Tableau compared to the one in the article that you have mentioned.

In case you are trying to connect through Knox gateway, this should help.

Also note that Druid is integrated with Hive in the Hortonworks distribution - HDP. It is on this cluster that this setting worked.

这篇关于将 Tableau 连接到 Apache Druid的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！