Support Questions

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

Cloudera Impala ODBC: Error In Tableau Desktop data extract: ETIMEDOUT

avatar
New Contributor

Hi guys,

 

I've got Tableau desktop 10.0 on my Windows7 OS configured with Cloudera Hadoop Impala connector trying to extract data from Impala sql query.

The connector I installed is ImpalaODBC Connector 2.6.0 with impala 2.7.0 jdbc service.

I tried to extract  about 20 million data , each row has 20 columns.

 

The desktop gives a “”[Cloudera][ImpalaODBC](120) Error while retrieving data from in Impala: [08S01]: ETIMEDOUT “” EXCEPTION

 

Does anyone have advice for investigating or fixing this?

 

Thanks,

-Jason

2 REPLIES 2

avatar
New Contributor

And the underlying data store is Kudu 

avatar
Super Guru
For ODBC related query failure, the info we can check are:

1. Impala query PROFILE, to understand which step failed
2. Impala coordinator log, using the query_id from PROFILE and see where it failed
3. enable TRACE logs on ODBC driver, to see if there is any client side errors :

https://www.cloudera.com/documentation/other/connectors/impala-odbc/latest/Cloudera-ODBC-Driver-for-...

search for LogLevel section. In Windows ODBC driver, normally under "Logging Options" button on the configuration window.