Cloudera Community

Welcome to the Cloudera Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Advanced Search
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Who agreed with this topic

Impala ODBC connection slow dataset fetch

avatar
author-rank TomasTF
Expert Contributor

Created on ‎01-15-2015 07:36 AM - last edited on ‎11-02-2017 01:39 PM by Community Manager Community Manager

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,415
0 Kudos
1
Tags (3)
Who agreed with this topic