dropbox / dropbox/PyHive

Error while connecting using auth=NONE

Open
#204 3 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

```
from pyhive import hive
conn = hive.Connection(host="localhost", port=10000, username="hive", auth="NONE")

cursor = conn.cursor()
cursor.execute("Show tables")
for table in cursor.fetchall():
print `table```

```

My hive server is configured to hive2.server.authentication of NONE. It keep returning the below error

`TTransportExceptionTraceback (most recent call last)
in ()
1 from pyhive import hive
----> 2 conn = hive.Connection(host="localhost", port=10000, username="hive", auth="NONE")
3
4 cursor = conn.cursor()
5 cursor.execute("Show tables")

/usr/lib/python2.7/site-packages/pyhive/hive.pyc in __init__(self, host, port, username, database, auth, configuration, kerberos_service_name, password, thrift_transport)
160
161 try:
--> 162 self._transport.open()
163 open_session_req = ttypes.TOpenSessionReq(
164 client_protocol=protocol_version,

/usr/lib/python2.7/site-packages/thrift_sasl/__init__.pyc in open(self)
77 if not ret:
78 raise TTransportException(type=TTransportException.NOT_OPEN,
---> 79 message=("Could not start SASL: %s" % self.sasl.getError()))
80
81 # Send initial response

TTransportException: Could not start SASL: Error in sasl_client_start (-4) SASL(-4): no mechanism available: No worthy mechs found`

only NOSASL work.

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.