question Not able to connect to hiveserver2 to access hivetables with python in Support Questions

question Not able to connect to hiveserver2 to access hivetables with python in Support Questions https://community.cloudera.com/t5/Support-Questions/Not-able-to-connect-to-hiveserver2-to-access-hivetables-with/m-p/270635#M207457 Can somebody please help me in connecting to hiveserver2 with python 2.7.5? hive-site.xml contains------------------------------- <property> <name>hive.server2.transport.mode</name> <value>http</value> <description>IP address (or fully-qualified domain name) and port of the metastore host</description> </property> <property> <name>hive.server2.thrift.http.port</name> <value>10001</value> </property> <property> <name>hive.server2.thrift.http.path</name> <value>cliservice</value> </property> <property> <name>hive.server2.authentication</name> <value>NOSASL</value> </property> <property> <name>hive.server2.thrift.bind.host</name> <value>localhost</value> </property> <property><name>hive.metastore.uris</name> <value>thrift://localhost:9083</value> </property> <property> <name>hive.metastore.event.db.notification.api.auth</name> <value>false</value> </property> Using beeline---------------- ./beeline SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/opt/hive/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/opt/hadoop-2.7.3/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See <A href="http://www.slf4j.org/codes.html#multiple_bindings" target="_blank">http://www.slf4j.org/codes.html#multiple_bindings</A> for an explanation. SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] Beeline version 3.1.2 by Apache Hive beeline> !connect jdbc:hive2://127.0.0.1:10001/default;auth=noSasl hive hive Connecting to jdbc:hive2://127.0.0.1:10001/default;auth=noSasl Java heap space 0: jdbc:hive2://127.0.0.1:10001/default (closed)> Connection is already closed.  With Pyhive------------ conn = hive.Connection(host='127.0.0.1', port=10002, username='hive', password='hive', database='default', auth='CUSTOM'). // tried auth ='CUSTOM'/'NOSASL' cur = conn.cursor() cur.execute('select * from employee limit 5') result = cur.fetchall()  File "connect_hive.py", line 47, in <module> output = hiveconnection(host_name, port, user,password, database) File "connect_hive.py", line 29, in hiveconnection database=database, auth='CUSTOM') File "/usr/lib/python2.7/site-packages/pyhive/hive.py", line 192, in __init__ self._transport.open() File "/usr/lib/python2.7/site-packages/thrift_sasl/__init__.py", line 80, in open status, payload = self._recv_sasl_message() File "/usr/lib/python2.7/site-packages/thrift_sasl/__init__.py", line 101, in _recv_sasl_message payload = read_all_compat(self._trans, length) File "/usr/lib/python2.7/site-packages/thrift_sasl/six.py", line 31, in <lambda> read_all_compat = lambda trans, sz: trans.readAll(sz) File "/usr/lib64/python2.7/site-packages/thrift/transport/TTransport.py", line 60, in readAll chunk = self.read(sz - have) File "/usr/lib64/python2.7/site-packages/thrift/transport/TSocket.py", line 132, in read message='TSocket read 0 bytes') thrift.transport.TTransport.TTransportException: TSocket read 0 byte using pyhs2-------------pyhs2.connect(host='localhost',port=10002, authMechanism="NOSASL", user='hive',password='hive',database='default')  Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/usr/lib/python2.7/site-packages/pyhs2/__init__.py", line 7, in connect return Connection(*args, **kwargs) File "/usr/lib/python2.7/site-packages/pyhs2/connections.py", line 47, in __init__ res = self.client.OpenSession(TOpenSessionReq(username=user, password=password, configuration=configuration)) File "/usr/lib/python2.7/site-packages/pyhs2/TCLIService/TCLIService.py", line 154, in OpenSession return self.recv_OpenSession() File "/usr/lib/python2.7/site-packages/pyhs2/TCLIService/TCLIService.py", line 165, in recv_OpenSession (fname, mtype, rseqid) = self._iprot.readMessageBegin() File "/usr/lib64/python2.7/site-packages/thrift/protocol/TBinaryProtocol.py", line 148, in readMessageBegin name = self.trans.readAll(sz) File "/usr/lib64/python2.7/site-packages/thrift/transport/TTransport.py", line 60, in readAll chunk = self.read(sz - have) File "/usr/lib64/python2.7/site-packages/thrift/transport/TTransport.py", line 162, in read self.__rbuf = BufferIO(self.__trans.read(max(sz, self.__rbuf_size))) File "/usr/lib64/python2.7/site-packages/thrift/transport/TSocket.py", line 132, in read message='TSocket read 0 bytes') thrift.transport.TTransport.TTransportException: TSocket read 0 bytes  Fri, 13 Sep 2019 09:36:54 GMT ranger 2019-09-13T09:36:54Z