Reply
New Contributor
Posts: 2
Registered: ‎12-11-2018

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

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

New Contributor
Posts: 2
Registered: ‎12-11-2018

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

And the underlying data store is Kudu 

Cloudera Employee
Posts: 573
Registered: ‎03-23-2015

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

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.
Announcements