Connection Error(TTransportException) to Hive using SQLAlchemy API
- Dominant language
- Python
- Stars
- 1.7k
- Forks
- 545
- PR merge metrics
- No merged PRs in 30d
Description
Hi.
I am trying to connect Hive server using PyHive and SQLAlchemy API with SASL as below code:
`ssl_args = {'ssl_cert': 'cacerts.pem'}`
`engine = create_engine("hive://username:password@hivetestserver.com:10000/default?auth=LDAP", connect_args=ssl_args)`
`insp = inspect(engine)`
But it makes error like below:
`
thrift.transport.TTransport.TTransportExceptiojn: Could not start SASL; b'Error in sasl_client_start (-4) SASL(-4): no mechanism avaliable: No worthy mechs found'
`
I tested it on Python 3.6.8 and two virtual environments.
first venv: SQLAlchemy==1.4.35, PyHive==0.6.5, sasl==0.2.1, thrift==0.10.0, thrift-sasl==0.3.0
second venv: SQLAlchemy==1.4.35, PyHive==0.6.5, sasl==0.3.1, thrift==0.16.0, thrift-sasl==0.4.3
Could you please let me know how to fix this issue?
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.