Member since
11-19-2019
3
Posts
0
Kudos Received
0
Solutions
11-20-2019
07:18 PM
Also would like to know, if SQL Server linked servers are supported using Cloudera Provider for Apache Hive.
... View more
11-20-2019
07:17 PM
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".
... View more
11-19-2019
01:10 PM
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
... View more
Labels:
- Labels:
-
Apache Hive