Tableau and Impala Connectivity Error

[#1]

Hello Team,

Have implemented Impala connectivity with Tableau and for some reason some dashboards are failing with error as :

com.tableausoftware.nativeapi.exceptions.DataSourceException: [Cloudera][ImpalaODBC] (120) Error while retrieving data from in Impala: [08S01] : ImpalaThriftAPICallFailed

Dashboard is getting refreshed on Tableau Desktop but giving above error on Tableau Server.

Impala version -ClouderaImpalaODBC 2.6.2.1002-1.x86_64

Tableau Server - 2018.3 and Centos OS

Please let me know how can this be resolved and fixed.

Thanks,
Mallika Singhi

BI Team

[#2]

Hi @jaya123,

Earlier when I have seen ImpalaThriftAPICallFailed it was due to a connection timeout between the client and Impala. Through ODBC/JDBC the connection can become inactive when Impala is executing the query, if the client tries to use a closed connection the call fails. The client might be trying to close the connection as well. Possible causes of the connection termination could be:

• A load balancer terminates the idle connection
• The driver closes the connection because SocketTimeout is reached

The TRACE level driver logs can help to identify how and when was the connection terminated the next steps could be:

1. Enable TRACE level driver logging, the log level and the log path has to be configured, please see our documentation here. This configuration is often client specific.
2. Open the connection logs and look for the ImpalaThriftAPICallFailed message.
3. Check the earlier messages, there could be other errors or the connection was probably closed just before the client request. The timestamps should help identify which timeout was reached, the SocketTimeout is 30s by default.

The timeouts could be reached because a slow query execution or because the client did not close the query. As the dashboard is refreshing it is probably because the client does not close the query. Just in case the query speed should be checked, if that is fine then the socket timeout could be increased a bit to give time for the client to close the query.

[#3]

thanks , will try implementing the same and get back to you incase of any more issues.

[#4]

您好：

咨询下您遇到的问题是否已解决，以及如何解决的，我现在遇到同样的问题，请求帮助！