https://community.cloudera.com/t5/Support-Questions/How-to-enable-a-pyhive-connection-with-python-3-5-SASL-issue/m-p/208130#M170089 <P>We (I should say, IT-team) find a solution</P><P>Upgrade of python packages thrift (to version 0.10.0) and PyHive (to version 0.3.0) don’t know why the version we used wasn’t the latest.</P><P>Added the following:</P><PRE>&lt;property&gt; &lt;name&gt;hive.server2.authentication&lt;/name&gt; &lt;value&gt;NOSASL&lt;/value&gt;&lt;/property&gt;</PRE><P>in the hive config</P><PRE>from pyhive import hive conn = hive.Connection(host="myserver", auth='NOSASL')import pandas as pd import sys df = pd.read_sql("SELECT * FROM my_table", conn)print(sys.getsizeof(df)) df.head()</PRE><P>worked without problem then.</P><P>Best,</P><P>Thomas</P> Tue, 20 Jun 2017 21:23:09 GMT burtom 2017-06-20T21:23:09Z