I have been trying to connect to impala using sqlalchemy and seem to be having lots of problem. This is my code:
engine = sqlalchemy.create_engine("impala://",creator= connect(host = "....", port=21050, database="default", auth_mechanism='LDAP',user="...",password="..." ,ca_cert= "..." ))
connection = engine.connect()
The following code throws the following exception "thrift.transport.TTransport.TTransportException: TSocket read 0 bytes".
I am also not completely confident about my auth_mechanism. In the previous version it was simply "authmech=3" so not sure what to put now between these options: "{'NOSASL', 'PLAIN', 'GSSAPI', 'LDAP', 'JWT'}"
connect(): https://github.com/cloudera/impyla/blob/master/impala/dbapi.py
I have tried adjusting the connection string in many ways but seem to always be getting some sort of error. My guess is that the problem is in the connection string of the create_engine function call
