title: Querying a HIVE Table from SQL Server 2016 or later
body: <p>I'm trying to query my Hortonworks cluster Hive tables from SQL Server. My scenario below:</p>
  
  <ul>
  <li>HDP 2.6, Ambari, HiveServer2</li>
  <li>SQL Server 2016 Enterprise</li>
  <li>Kerberos configuration for secure logins in HDP</li>
  </ul>
  
  <p>I was reading about the PolyBase service in SQL Server 2016 and I suppose later versions. However, I realize that according to the <a href="https://docs.microsoft.com/en-us/sql/relational-databases/polybase/get-started-with-polybase" rel="nofollow noreferrer">documentation</a> what this service is going to perform in SQL Server is a bridge to reach out my HDFS and recreate external tables based in this data source. </p>
  
  <p>Otherwise what I'm expecting is query Hive objects like these would be SQL Server objects as well, such as a linked server.</p>
  
  <p>Someone has an example or knows if this is possible within SQL Server and Hive?</p>
  
  <p>Thanks so much</p>