title: Add HIVE link server in SQL after set an ODBC hortonworks
body: <p>I'm using a couple of Hortonworks services to store huge data, the most common service I use is Hive. the thing is that know I need to analyze from SQL Server 2014. I went thru the documentation and I've already successfully added a new ODBC for my HDP clusted. (HDP 2.6)</p>
  
  <p><a href="https://i.stack.imgur.com/rXGyO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rXGyO.png" alt="enter image description here"></a></p>
  
  <p>Following a couple of tutorials (<a href="https://www.oraylis.de/blog/querying-hadoop-from-sql-server" rel="nofollow noreferrer">example1</a> and <a href="http://thinknook.com/connecting-sql-server-and-analysis-services-to-hadoop-hive-2013-07-09/" rel="nofollow noreferrer">Example2</a> )I've tried to add a new link server. however these codes are not using a kerberos authentication in their queries.</p>
  
  <pre><code>EXEC master.dbo.sp_addlinkedserver
  @server = ‘[32-bit HIVE ODBC]’
  , @srvproduct=’HIVE’
  , @provider=’MSDASQL’
  , @datasrc='[hive-data-source]’
  , @provstr=’Provider=MSDASQL.1;Persist Security Info=True;User ID=[username];’
  </code></pre>
  
  <p>Please if someone can give me a hand with the last parameter <strong>@provstr</strong> using kerberos configuration, I appreciate.</p>
  
  <p>thanks so much.</p>