Hive connection

[superibra]

I'm new at superset
When i want to connect to hive database that shows me this error
TTransportException(message="Could not start SASL: b'Error in sasl_client_start (-4) SASL(-4): no mechanism available: No worthy mechs found'", type=1"
i'm blocked for 6days in this error
did you know how to solve this error ?

[xrmx]

Googling for the error in this 6 days may have helped:
cloudera/impyla#149 (comment)

That's an issue with the connector, not a superset issue.

[superibra]

Before i wrote this post. I followed the answer in the 149 post with attention but it remains the same error. that's why i will see if i can find a solution to this issue at pyhive forum
Thank you for answering

[hungrytortoise]

Has the problem been solved?

[hungrytortoise]

@superibra

[mistercrunch]

You may want to try auth=plain or auth=PLAIN

[hungrytortoise]

i have done what you say,but meet a new error.
ERROR: {"error": "Connection failed!\n\nThe error message returned was:\nOnly NONE & NOSASL authentication are supported, got PLAIN"}
my SQLAlchemy URI is "hive://hive@xxxxxx:10000/xxx_idmapping?auth=PLAIN"
how to fix it ?
tks

[mistercrunch]

Did you try NONE?

[hungrytortoise]

i have tried it,but meet the following issue.
ERROR: {"error": "Connection failed!\n\nThe error message returned was:\nCould not start SASL: Error in sasl_client_start (-4) SASL(-4): no mechanism available: No worthy mechs found"}

[mistercrunch]

Here's the related pyhive logic:
https://github.com/dropbox/PyHive/blob/59746c31f1b16c96e90a5dd2cb00e23b30d3caea/pyhive/hive.py#L91

[panhuida]

@superibra @hungrytortoise @mistercrunch , I guess the pyhive package only support python2.7, not support python 3.

https://pypi.python.org/pypi/PyHive/0.2.1
Requirements

Install using

pip install pyhive[hive] for the Hive interface and
pip install pyhive[presto] for the Presto interface.
PyHive works with

Python 2.7
For Presto: Presto install
For Hive: HiveServer2 daemon
There’s also a third party Conda package.

[sungjuly]

That's true, let's wait a couple of days, PyHive is trying to support Python3 since data scientist guy from Airbnb contributes for that, I expect new version will be rolled out soon!

• dropbox/PyHive@e3ecad1

[maygupta]

@superibra @hungrytortoise Were you able to solve this issue ?

[SpyderRivera]

Any update on this? Did you get it working? Did you try python 2.7?

[pranavoyo]

hitting this issue with superset version 0.26.3 and pyhive 0.6.0; please assist

[sunriseLe]

@superibra @hungrytortoise @mistercrunch , I guess the pyhive package only support python2.7, not support python 3.

https://pypi.python.org/pypi/PyHive/0.2.1
Requirements

Install using

pip install pyhive[hive] for the Hive interface and
pip install pyhive[presto] for the Presto interface.
PyHive works with

Python 2.7
For Presto: Presto install
For Hive: HiveServer2 daemon
There’s also a third party Conda package.

after insatll pyhive[presto], I can access presto, no error like that:
Invalid driver: presto