Can't load plugin: sqlalchemy.dialects:jdbc.hive

user_5006996 0
Viewed 6454

I'm trying to build an application with superset, I've installed superset, Hive on my Hadoop cluster and I'm trying to connect to my Hive data base with super set but every time, I try to do so I receive this error:

ERROR: {"error": "Connection failed!\n\nThe error message returned was:\nCan't load plugin: sqlalchemy.dialects:jdbc.hive"}

Once I click on the "Test Connection" button.

Please does any one have a solution for this ? Here's a screen shot of the problem

superset hive jdbc sqlalchemy
1 Answers

For me in HDP with ambari:

cd /usr/hdp/3.1.4.0-315/superset/bin/
./pip3.6 install sasl
./pip3.6 install thrift_sasl
./pip3.6 install pyhive

Test:

./python3.6
>>from sqlalchemy.engine import create_engine
>>engine = create_engine('hive://localhost:10000/default')

without errors. Restart superset and work

user_74243650
Related