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 Cloudera Hive DB is not fetching results.

Highlighted

SQL Server linked server to Cloudera Hive DB is not fetching results.

New Contributor

We have setup a linked server from SQL Server to Hive using Cloudera driver for Apache Hive.

 

We are unable to fetch results from non public tables with SQL authentication impersonation in linked server.

 

Is there something that should be modified at SQL Linked server level

3 REPLIES 3

Re: SQL Server linked server to Cloudera Hive DB is not fetching results.

Mentor

@DBA123 

Can you share the connection and SQL being executed? You should fully qualify the tables like dbo.x thats my guess. but seeing the SQL would help.

 

HTH

Highlighted

Re: SQL Server linked server to Cloudera Hive DB is not fetching results.

New Contributor

Hello Shelton,

This is the query :

 

select * from openquery ([linked server], 'select * from [schema].[table] limit 5')

 

Error:

 

OLE DB provider "MSDASQL" for linked server "linked server " returned message "[Cloudera][SQLEngine] (31740) Table or view not found: HIVE.schema.table".
Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing the query "select * from [schema].[table] limit 5" for execution against OLE DB provider "MSDASQL" for linked server "Linked Server".

Highlighted

Re: SQL Server linked server to Cloudera Hive DB is not fetching results.

New Contributor

Also would like to know, if SQL Server linked servers are supported using Cloudera Provider for Apache Hive.

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