I set up a connection to a Hive server using the Hortonworks ODBC Driver for Apache Hive. Version info is below: OS: Windows Server 2012 R2 Standard Hive: 1.2.1000.2.6.5.4-1 Hadoop: 220.127.116.11.6.5.4-1 ODBC Driver for Apache Spark ODBC Version: 03.80 Driver Version: 18.104.22.1687 Bitness: 64-bit Locale: en_US I can run the queries below using the connector that I configured in Teradata SQL Assistant with no issues. I set up my DSN as a linked server in SSMS. However, when I attempt to run queries in SSMS using openquery, I have some issues. Info on my SQL Server is below: Microsoft SQL Server 2016 (SP2-CU3) (KB4458871) - 13.0.5216.0 (X64) Sep 13 2018 22:16:01 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor) Here is some info on the table that I am querying: Table Name: instrumentapps_event col_name data_type 1 load_ts string 2 event string 3 data_dt string Using OPENQUERY, I am capable of querying the Hive DB through SSMS with the following query: SELECT * FROM OPENQUERY(KMhivehttp, 'select * from dmfwk_gold.instrumentapps_event') The above query returns the contents of the desired table. However, the query below produces an error: SELECT * FROM OPENQUERY(KMhivehttp, 'select * from dmfwk_gold.instrumentapps_event WHERE to_date(from_unixtime(UNIX_TIMESTAMP(load_ts,''yyyy/MM/dd''))) >= to_date(''2019-03-01'')') The error is as follows: Msg 7355, Level 16, State 1, Line 1 The OLE DB provider "MSDASQL" for linked server "KMhivehttp" supplied inconsistent metadata for a column. The name was changed at execution time. How can I fix this?
... View more
@Julian are you saying that the above options need to be selected? I'm getting the same error, but I even get the error when I use openquery. I detail specifics here: https://community.hortonworks.com/questions/242899/why-is-my-hive-ql-query-that-i-run-in-ssms-via-ope.html
... View more