SQL Server Linked Server To Impala Setup

[#1]

Hi All,

Are there any instructions/guides on how to setup a linked server from SQL Server to Impala (and Hive)?

I have a working ODBC connection setup but can't figure out how to configure the linked server within SQL Server itself.

Thanks

[#2]

Theres already a community answer on this...
https://community.cloudera.com/t5/Support-Questions/Can-t-select-from-Impala-as-a-linked-server-on-S...

[#3]

That doesn't explain how to setup the linked server step-by-step - That's the info i need

[#4]

Below are the step by step approach for making SQL Server Linked Server to work with Cloudera Impala.

As SQL Server is 64 bit product, we have to install Cloudera Impala 64 bit ODBC driver to make it

working with SQL Server linked service.

We need to follow the below steps:

1. Install Cloudera Impala 64 bit driver in the same SQL Server machine and set up the DSN with below settings.

2. Now, create linked server in SQL Server with below settings. Product name, Datasource  should be the same as the name created in DSN.

Now, the impala queries will work fine without issues, using SQL Server linked server. We had unicode data pull issues and we solved it by going for above settings. 

[#5]

How do I find the product name?

[#6]

As mentioned in the post, Product name is same as DSN name. 

[#7]

I try the same name but I got error:

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "IMPALA".

OLE DB provider "MSDASQL" for linked server "IMPALA" returned message "[Cloudera][KerberosSupport] (0) Error occurred during Kerberos library operation: Internal credentials cache error". (Microsoft SQL Server, Error: 7303)

[#8]

Thanks Trollied. I tried as you suggested but get the error;

Msg 7313, Level 16, State 1, Line 1 An invalid schema or catalog was specified for the provider "MSDASQL" for linked server "Netsuite".

Any other thoughts.