dropbox / dropbox/PyHive

Connection Error(TTransportException) to Hive using SQLAlchemy API

Open
#436 0 comments 0 reactions 0 assignees View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.