title: Write DataFrame to Hive using pyodbc DSN connection
body: <p>How to write dataframe to hive table using pyodc connection. When written it gives programming error.. any other way to write data to hive from local.</p>
  <p>error</p>
  <pre><code>Error                                     Traceback (most recent call last)
  C:\ProgramData\Anaconda3\lib\site-packages\pandas\io\sql.py in execute(self, *args, **kwargs)
     1430             else:
  -&gt; 1431                 cur.execute(*args)
     1432             return cur
  
  Error: ('HY000', &quot;[HY000] [Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : ParseException: Syntax error in line 1:\n...ERE type='table' AND name=?;\n                             ^\nEncountered: Unexpected character\nExpected: CASE, CAST, DEFAULT, EXISTS, FALSE, IF, INTERVAL, LEFT, NOT, NULL, REPLACE, RIGHT, TRUNCATE, TRUE, IDENTIFIER\n\nCAUSED BY: Exception: Syntax error\n (110) (SQLPrepare)&quot;)
  </code></pre>
  <p>During handling of the above exception, another exception occurred:</p>
  <pre><code>DatabaseError                             Traceback (most recent call last) &lt;ipython-input-8-9f82c88c3a27&gt; in &lt;module&gt;
        1 import pyodbc
        2 with pyodbc.connect(&quot;DSN=*****&quot;, autocommit=True) as conn:
  ----&gt; 3     df.to_sql(name='Xyz', con=conn, schema='fgh',if_exists='append',index=False)
  </code></pre>