如何连接vertica和apache超集？

Question

我正在尝试将vertica与apache superset连接起来

超集-->添加数据库--> SQLAlchemy URI : vertica+vertica_python://dbadmin:password@localhost:5433/test

我在docker中运行apache超集，在localhost中运行vertica。

我检查了超集的docker镜像的日志，得到错误

Traceback (most recent call last):
  File "/home/superset/superset/views/core.py", line 1759, in testconn
    engine = create_engine(uri, **engine_params)
  File "/usr/local/lib/python3.6/site- 
packages/sqlalchemy/engine/__init__.py", line 419, 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 150, in _get_entrypoint
    cls = registry.load(name)
  File "/usr/local/lib/python3.6/site- 
packages/sqlalchemy/util/langhelpers.py", line 201, in load
    return self.impls[name]()
  File "/usr/local/lib/python3.6/site- 
packages/pkg_resources/__init__.py", line 2433, in load
    self.require(*args, **kwargs)
  File "/usr/local/lib/python3.6/site- 
packages/pkg_resources/__init__.py", line 2456, in require
    items = working_set.resolve(reqs, env, installer, 
extras=self.extras)
  File "/usr/local/lib/python3.6/site- 
packages/pkg_resources/__init__.py", line 794, in resolve
    new_requirements = dist.requires(req.extras)[::-1]
  File "/usr/local/lib/python3.6/site- 
packages/pkg_resources/__init__.py", line 2735, in requires
    "%s has no such extra feature %r" % (self, ext)
pkg_resources.UnknownExtra: vertica-python 0.9.2 has no such extra 
feature 'namedparams'

Answer 1

试一试

pip install sqlalchemy-vertica

而不是

pip install sqlalchemy-vertica-python