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

SQL Server Linked Server to HIVE Database Creation Issue

Highlighted

SQL Server Linked Server to HIVE Database Creation Issue

New Contributor

Hi, I have downloaded the ClouderaHive ODBC driver and installed it on the SQL 2016 Server. I created a system DSN using Kerebos and successfully connected to the Hive database.  However, we need a linked server to be created and whenever I try to create it, I get an error message:

 

The OLE DB provider "MSDASQL" for linked server "HADOOP" reported an error. The provider did not give any information about the error.
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "HADOOP". (.Net SqlClient Data Provider)

 

I have tried all the different Linked Server security options, but it just won't work.

Can anyone give me some guidance?

Thank you.

 

Don't have an account?
Coming from Hortonworks? Activate your account here