Connection Error(TTransportException) to Hive using SQLAlchemy API
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 25/100
Research direction
Start by reproducing the SQLAlchemy create_engine and inspect(engine) connection with the listed PyHive, sasl, thrift, and thrift-sasl versions. Trace the reported TTransportException through the SASL connection path and determine whether a supported mechanism or dependency configuration is missing; done means the cause and a verified fix or limitation are documented.
Written by the indexing model from the issue text.
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:[email protected]: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?
- Dominant language
- Python
- Stars
- 1.7k
- Forks
- 544
- PR merge metrics
- No merged PRs in 30d
Getting set up
This project ships no dev container, Dockerfile or contributing guide, so setting up is up to you: start from its README, and see our first-contribution guide for the general steps.
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from dropbox/PyHive
-
Difficulty 4/5 3-5 days Newbie friendliness 25/100
-
Difficulty 3/5 1-2 days Newbie friendliness 35/100
-
Difficulty 3/5 1-2 days Newbie friendliness 35/100
-
Difficulty 4/5 3-5 days Newbie friendliness 35/100
-
Difficulty 5/5 Over a week Newbie friendliness 20/100
Similar issues
-
New InternshipOpennew_internship
Difficulty 1/5 Under an hour Newbie friendliness 70/100
-
[BUG] Reports tab: "Unban" button tooltip shows raw `{{ip}}` placeholder instead of the IP addressOpenbug javascript ui
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
bunkerity/bunkerweb#4001 · 1 comment ·
Maintainers usually reply within 1 day
-
bug
Difficulty 1/5 Under an hour Newbie friendliness 92/100
PedestrianDynamics/pyFDS-Evac#476 ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
google/differential-privacy#516 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 82/100
adobe-fonts/source-serif#153 ·