Member since
08-20-2018
1
Post
0
Kudos Received
0
Solutions
08-20-2018
12:42 PM
Hi All, When I execute the Query "SELECT * FROM [hadoop].[HIVE].[test].[u_movie2]" with Microsoft SQL Server Management Studio at Hive, I get the following message: Msg 7355, Level 16, State 1, Line
2
The OLE DB provider "MSDASQL" for linked server "hadoop"
supplied
inconsistent metadata for a column. The name was changed at execution time. But Openqueries can be executed well. So the Query "SELECT * FROM openquery(Hadoop,'SELECT * FROM u_movie2')" will be performed by Hive. But I would like to use the first Variant, because it is easier to understand. I tried many combinations of Linked Server Properties and ODBC Driver Properties, but Nothing what I tried can solve my Problem. I am using following Components:
Hadoop-3.0.2 Hive-3.1.0 Hortonworks Hive ODBC Driver 2.1.16 (64 bit) Thanks Dennis
... View more
Labels:
- Labels:
-
Apache Hive