Hi Guitao, Can you provide more info about the query which you have ran? Thanks -Rahman ...
Can you provide more info about the query which you have ran?
I’m using SQL Server and created a linked server to do queries using hive.
But now i found when i use openquery(hive, ‘query sql’), the query run twice on the hive side.
I’m using Hortonworks Hive ODBC Driver 1.2 (64 bit).
I’m not sure if the first query is to get the metadata of the query result. If so, too silly….
What should I do to avoid this? This is really annoying for taking much longer time to get the result.
A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.
Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world