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

[#1]

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]

And the underlying data store is Kudu 

[#3]

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.