Can't work with clickhouse

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
then get the error:
Traceback (most recent call last):
File “/usr/share/hue/desktop/libs/notebook/src/notebook/”, line 695, in close_notebook
File “/usr/share/hue/desktop/libs/notebook/src/notebook/connectors/”, line 416, in close_session
engine = self._get_engine()
File “/usr/share/hue/desktop/libs/notebook/src/notebook/connectors/”, line 141, in _get_engine
ENGINES[engine_key] = self._create_engine()
File “/usr/share/hue/desktop/libs/notebook/src/notebook/connectors/”, line 207, in _create_engine
return create_engine(url, **options)
File “/usr/share/hue/build/env/lib/python3.6/site-packages/sqlalchemy/engine/”, line 456, in create_engine
return strategy.create(*args, **kwargs)
File “/usr/share/hue/build/env/lib/python3.6/site-packages/sqlalchemy/engine/”, line 87, in create
dbapi = dialect_cls.dbapi(**dbapi_args)
File “/usr/share/hue/build/env/lib/python3.6/site-packages/sqlalchemy_clickhouse/”, line 185, in dbapi
import connector
ModuleNotFoundError: No module named ‘connector’

hui.ini like below
options=’{“url”: “clickhouse://xxxx:8123”}’

Thank you !

Good point!

Seems like the pytz module in Hue is super old (2005).


./build/env/bin/pip install pytz==2021.1

It works for me. Will update the docs.