Dear admin:
I’m a clickhouse user ,but it seems can’t work with clickhouse-sqlalchemy ( 0.1.5)
the detail is below:
setup in docker container
docker run -tid -p 7777:8888 --name hue -v /gwmfc/hue-latest/hue.ini:/usr/share/hue/desktop/conf/hue.ini hue:latest
then install the clickhouse-sqlalchemy in docker container
docker exec -it hue /bin/bash
./build/env/bin/pip install sqlalchemy-clickhouse
open the hue
http://xxxx:7777
then get the error:
Traceback (most recent call last):
File “/usr/share/hue/desktop/libs/notebook/src/notebook/api.py”, line 695, in close_notebook
response[‘result’].append(api.close_session(session))
File “/usr/share/hue/desktop/libs/notebook/src/notebook/connectors/sql_alchemy.py”, line 416, in close_session
engine = self._get_engine()
File “/usr/share/hue/desktop/libs/notebook/src/notebook/connectors/sql_alchemy.py”, line 141, in _get_engine
ENGINES[engine_key] = self._create_engine()
File “/usr/share/hue/desktop/libs/notebook/src/notebook/connectors/sql_alchemy.py”, line 207, in _create_engine
return create_engine(url, **options)
File “/usr/share/hue/build/env/lib/python3.6/site-packages/sqlalchemy/engine/init.py”, line 456, in create_engine
return strategy.create(*args, **kwargs)
File “/usr/share/hue/build/env/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py”, line 87, in create
dbapi = dialect_cls.dbapi(**dbapi_args)
File “/usr/share/hue/build/env/lib/python3.6/site-packages/sqlalchemy_clickhouse/base.py”, line 185, in dbapi
import connector
ModuleNotFoundError: No module named ‘connector’
hui.ini like below
[notebook]
[[interpreters]]
[[[clickhouse]]]
name=ClickHouse
interface=sqlalchemy
options=’{“url”: “clickhouse://xxxx:8123”}’
Thank you !