Reply
Contributor
Posts: 40
Registered: ‎09-26-2014

Impala ODBC connection slow dataset fetch

[ Edited ]

We have an Impala 2.1 with ODBC connector 2.5.20. This connection is linked to MS SQL server. The problem is, that queries with larger datasets (such as thousands of rows) are running extremely slow. Queries such as (select count(*) from table) runs ok, because the query is executed in Impala and then the result is returned and fetched by MS SQL Server  - 1 row.

 

Is there any setting or configuration property in the ODBC connector to improve the performance for queries returning larger datasets?

 

Thanks

Tomas

 

 

Highlighted
Explorer
Posts: 34
Registered: ‎07-17-2017

Re: Impala ODBC connection slow dataset fetch

Announcements