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?