Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Tableau and Impala Connectivity Error

Tableau and Impala Connectivity Error

New Contributor
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
3 REPLIES 3
Highlighted

Re: Tableau and Impala Connectivity Error

Contributor

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.

Highlighted

Re: Tableau and Impala Connectivity Error

New Contributor

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

Highlighted

Re: Tableau and Impala Connectivity Error

New Contributor

您好:

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

Don't have an account?
Coming from Hortonworks? Activate your account here