Cloudera Impala连接到Tableau错误

问题描述

我正在使用Tableau连接到Cloudera Hadoop。我提供服务器和端口的详细信息，并使用Impala进行连接。我能够成功连接，选择默认模式并选择所需的表。

I am working on using Tableau to connect to Cloudera Hadoop. I provide the server and port details and connect using Impala. I am able to successfully connect, select default Schema and choose the required table(s).

在此之后，当我将维或度量拖放到行时/ 网格上的列，出现以下错误：

After this, when I drag and drop either a dimension or a measure to Rows/Columns on the grid, I get the below error:

[Cloudera][Hardy] (22) Error from ThriftHiveClient:
Query returned non-zero code: 10025, cause: FAILED:
SemanticException [Error 10025]: Line 1:7 Expression not in GROUP BY key ''.

我在论坛上看到了几个类似的问题，但没有一个得到解决方案。

I saw several similar problems on the forum, but none of them got the solution Any help on this is very much appreciated?

推荐答案

我之前遇到过同样的问题。当Tableau尝试运行以下内容时会发生错误：

I encountered the same problem before. The error occurs when Tableau try to run something like this:

   SELECT `table`.`param_1` AS `param_1`
   ,SUM(`table`.`param_2`) AS `sum_all`
   FROM `db_name`.`table`
   `table` GROUP BY 1

因为您可以检查架构和表。此聚合可能会导致此问题。

Since you can check the schema and tables. This aggregation may cause the problem.

我认为您可能需要检查一些事情：

I think you might need to check a few things:

1. 是您的吗？ odbc驱动程序版本正确吗？ Cloudera ODBC驱动程序2.5.28
   不支持带Impala的Tableau。


2. 您选择了正确的端口号或登录类型吗？ Impala端口
   的号码是21000和21050。蜂巢是10000。

对我来说，设置是使用21050端口，然后将Impala选择为不进行身份验证的类型 。您还可以选择Type HiveServer2并使用impala端口号登录。

For me the setup is using port 21050 and choose Impala as Type with no authentication. You can also choose Type HiveServer2 and using impala port number to login. But it didn't work on my case.

希望有帮助。

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