[GitHub] [incubator-superset] stevenlevey edited a comment on issue #5307: Can't load plugin sqlalchemy.dialects:druid

[GitBox <gi...@apache.org>]

stevenlevey edited a comment on issue #5307:
URL: https://github.com/apache/incubator-superset/issues/5307#issuecomment-630115580


   I have the same issue running inside the Docker Container. Does anyone have a solution to this?
   
   This is query string I add into "SQLAlchemy URI"
   
   druid://broker_druid:8082/druid/v2/sql/
   
   
   This is the error I get:
   
   ERROR: {"error": "Connection failed!\n\nThe error message returned was:\nCan't load plugin: sqlalchemy.dialects:druid"}
   
   If I login to the Superset Container and check for the PyDruid version, I am running the latest version (pydruid==0.5.9)
   
   From within the shell of the Superset container I can use curl successfully to query the broker and get results back (using SQL).
   
   However, if I open up a Python repl in the Superset Container, and I use:
   
   ```
   from sqlalchemy import *
   from sqlalchemy.engine import create_engine
   from sqlalchemy.schema import *
   
   engine = create_engine('druid://localhost:8082/druid/v2/sql/')
   ``` 
   I get the same error I get from the Superset UI mentioned above.
   
   engine = create_engine('druid://broker_druid:8082/druid/v2/sql/')
   Traceback (most recent call last):
     File "<stdin>", line 1, in <module>
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/__init__.py", line 387, in create_engine
       return strategy.create(*args, **kwargs)
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 56, in create
       entrypoint = u._get_entrypoint()
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/url.py", line 139, in _get_entrypoint
       cls = registry.load(name)
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 218, in load
       (self.group, name))
   sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:druid


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org