I'm trying to use Impala 2.5 as a linked server on SQL Server using Cloudera's ODBC drivers (version 2.05.35.1006). I was able to define a data source and see the tables from the catalog however when I try to execute a SELECT statement I get the following error:
Msg 7399, Level 16, State 1, Line 5 The OLE DB provider "MSDASQL" for linked server "IMPACTIMPALAU" reported an error. The provider did not give any information about the error. Msg 7312, Level 16, State 1, Line 5 Invalid use of schema or catalog for OLE DB provider "MSDASQL" for linked server "IMPACTIMPALAU". A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema.
I was able to do the same from SQL Server 2014 32-bit to Impala 2.6.0 and the query executed just fine.
Any ideas what needs to be fixed?
The error you added on the post, was it the error you see from SQL Server?
Can you please post the error message from
- ODBC driver debug log
- Impala daemon log ( the one used as coordinator for the select query, which is the one that SQL Server connects to)
For ODBC driver debug log, please refer to:
and check section "Configuring Logging Options".
Thanks for your response. It took me quite a bit but I was able to read from Impala eventually. It seems that I had to use "three dot notation" from SQL Server (i.e. SELECT * FROM impala...table1).