question Re: SQL Server Linked Server To Impala Setup in Support Questions

SQL Server Linked Server To Impala Setup

whited001 — Thu, 05 Nov 2020 16:38:56 GMT

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

Re: SQL Server Linked Server To Impala Setup

Mike in Austin — Tue, 10 Nov 2020 22:20:41 GMT

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

Re: SQL Server Linked Server To Impala Setup

whited001 — Wed, 11 Nov 2020 11:28:52 GMT

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

Re: SQL Server Linked Server To Impala Setup

rvenkat — Fri, 13 May 2022 09:08:23 GMT

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.

Re: SQL Server Linked Server To Impala Setup

Shabahang — Wed, 30 Nov 2022 11:18:44 GMT

How do I find the product name?

Re: SQL Server Linked Server To Impala Setup

rvenkat — Wed, 30 Nov 2022 13:04:07 GMT

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

Re: SQL Server Linked Server To Impala Setup

Shabahang — Sat, 03 Dec 2022 09:55:43 GMT

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)

Re: SQL Server Linked Server To Impala Setup

yaaraaja4 — Sat, 03 Dec 2022 12:50:40 GMT

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.