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

Who agreed with this solution

Re: Impala ODBC performance

Cloudera Employee
We set up two linked servers from on SQL Server instance to another SQL Server instance. One using our ODBC driver for SQL Server and one using our OLE DB provider for SQL Server. We tested using a table with 500000 rows, 7 columns and 5 different datatypes. We ran the performance tests using both the OPENQUERY syntax and without the OPENQUERY syntax but the performance is quite close between the two syntax.
Who agreed with this solution