Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Tableau and Impala Connectivity Error

avatar
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
6 REPLIES 6

avatar
Expert 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.

avatar
New Contributor

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

avatar
New Contributor

您好:

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

avatar
Explorer

Have you solved this problem? I also encountered the same problem. thanks

avatar
Community Manager

@kunzhao, as this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post.



Regards,

Vidya Sargur,
Community Manager


Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Learn more about the Cloudera Community:

avatar
Cloudera Employee

Which version of CDP are you using please?