<property> <name>hive.server2.authentication</name> <value>NONE</value> <final>false</final> <source>programmatically</source> <source>org.apache.hadoop.hive.conf.LoopingByteArrayInputStream@3fffff43</source> </property> ... View more

it works when i use 127.0.0.1 or localhost ，but error when i use hostname or remote hostname。   thrift 0.16.0 thrift-sasl 0.4.3 thriftpy 0.3.9 thriftpy2 0.4.14 ... View more

>>> impala_conn = connect(host='emr-header-3', port=21050, database="dim", user="api",password="",auth_mechanism='PLAIN') DEBUG:impala.hiveserver2:Connecting to HiveServer2 emr-header-3:21050 with PLAIN authentication mechanism DEBUG:impala._thrift_api:get_socket: host=emr-header-3 port=21050 use_ssl=False ca_cert=None DEBUG:impala.hiveserver2:sock=<thriftpy2.transport.socket.TSocket object at 0x7f366e85b2b0> DEBUG:impala._thrift_api:get_transport: socket=<thriftpy2.transport.socket.TSocket object at 0x7f366e85b2b0> host=emr-header-3 kerberos_service_name=impala auth_mechanism=PLAIN user=api password=fuggetaboutit Please enter your password: Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/home/hadoop/.local/lib/python3.6/site-packages/impala/dbapi.py", line 150, in connect http_path=http_path) File "/home/hadoop/.local/lib/python3.6/site-packages/impala/hiveserver2.py", line 826, in connect transport.open() File "/home/hadoop/.local/lib/python3.6/site-packages/thrift_sasl/__init__.py", line 93, in open status, payload = self._recv_sasl_message() File "/home/hadoop/.local/lib/python3.6/site-packages/thrift_sasl/__init__.py", line 112, in _recv_sasl_message header = self._trans_read_all(5) File "/home/hadoop/.local/lib/python3.6/site-packages/thrift_sasl/__init__.py", line 198, in _trans_read_all return read_all(sz) File "/usr/local/lib64/python3.6/site-packages/thriftpy2/transport/socket.py", line 132, in read message='TSocket read 0 bytes') thriftpy2.transport.base.TTransportException: TTransportException(type=4, message='TSocket read 0 bytes') ... View more