https://community.cloudera.com/t5/Support-Questions/How-to-enable-a-pyhive-connection-with-python-3-5-SASL-issue/m-p/208129#M170088 <P>Hi,</P><P>I'm a Hadoop newbie, so don't shoot me yet. I tried to set a hive connection as described here <A href="https://community.hortonworks.com/articles/97062/query-hive-using-python.html">query-hive-using-python.html</A></P><P>I want to set a hive connection using the hive.Connection with python 3.5.2 but the SASL package seems to cause a problem. I saw on a forum that SASL is compatible only with 2.7 python. Is that right ?</P><P>Thank you in advance ! Tom</P><PRE>from pyhive import hive#conn = hive.Connection(host="myserver", port=10000)conn = hive.Connection(host="myserver")import pandas as pd</PRE> <PRE>TTransportException Traceback (most recent call last)in ()1 from pyhive import hive2 #conn = hive.Connection(host="myserver", port=10000)----&gt; 3 conn = hive.Connection(host="myserver") import pandas as pd/opt/anaconda3/lib/python3.5/site-packages/pyhive/hive.py in init(self, host, port, username, database, auth, configuration)102103 try:--&gt; 104 self._transport.open()105 open_session_req = ttypes.TOpenSessionReq(106 client_protocol=protocol_version,/opt/anaconda3/lib/python3.5/site-packages/thrift_sasl/init.py in open(self)70 if not ret:71 raise TTransportException(type=TTransportException.NOT_OPEN,---&gt; 72 message=("Could not start SASL: %s" % self.sasl.getError()))7374 # Send initial responseTTransportException: TTransportException(message="Could not start SASL: b'Error in sasl_client_start (-4) SASL(-4): no mechanism available: No worthy mechs found'", type=1)</PRE> Tue, 13 Jun 2017 22:06:35 GMT burtom 2017-06-13T22:06:35Z