title: Python Connection to Hive
body: <p>I installed the Hortonworks Hive ODBC driver and created a connection in the Data sources. I tested it and it worked successfully.</p>
  
  <p>I installed PyODBC and wrote the following code</p>
  
  <pre><code>import os, sys, pyodbc;
  con = pyodbc.connect("DSN=MyCon")
  </code></pre>
  
  <p>I got error</p>
  
  <pre><code>Traceback (most recent call last):
    File "&lt;stdin&gt;", line 1, in &lt;module&gt;
  pyodbc.Error: ('HYC00', '[HYC00] [Hortonworks][ODBC] (11470) Transactions are not supported. (11470) (SQLSetConnnectAttr(SQL_ATTR_AUTOCOMMIT))')
  </code></pre>
  
  <p>I also tried</p>
  
  <pre><code>import pyodbc, sys, os
  pyodbc.pooling = False
  pyodbc.autocommit = False
  con = pyodbc.connect("DSN=MyCon")
  
  Traceback (most recent call last):
    File "&lt;stdin&gt;", line 1, in &lt;module&gt;
  pyodbc.Error: ('HYC00', '[HYC00] [Hortonworks][ODBC] (11470) Transactions are not supported. (11470) (SQLSetConnnectAttr(SQL_ATTR_AUTOCOMMIT))')
  </code></pre>
  
  <p>also tried </p>
  
  <pre><code>con = pyodbc.connect("DSN=Tenet", autocommit=False)
  
  
  Traceback (most recent call last):
    File "&lt;stdin&gt;", line 1, in &lt;module&gt;
  pyodbc.Error: ('HYC00', '[HYC00] [Hortonworks][ODBC] (11470) Transactions are not supported. (11470) (SQLSetConnnectAttr(SQL_ATTR_AUTOCOMMIT))')
  </code></pre>