Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Impala ODBC connection slow dataset fetch

Highlighted

Impala ODBC connection slow dataset fetch

Rising Star

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

 

 

2 REPLIES 2

Re: Impala ODBC connection slow dataset fetch

Expert Contributor

Re: Impala ODBC connection slow dataset fetch

Expert Contributor
Don't have an account?
Coming from Hortonworks? Activate your account here