You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2021/02/02 04:46:19 UTC
[GitHub] [superset] calipeng opened a new issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
calipeng opened a new issue #12881:
URL: https://github.com/apache/superset/issues/12881
URI String is : clickhouse://gpsec:xxx@xxx:8858/sec
docker-compose logs -f -t superset
uperset_app | 2021-02-02T03:23:36.323066230Z 172.17.0.233 - - [02/Feb/2021 03:23:36] "GET /api/v1/database/_info?q=(keys:!(permissions)) HTTP/1.1" 200 -
superset_app | 2021-02-02T03:23:36.323076390Z INFO:werkzeug:172.17.0.233 - - [02/Feb/2021 03:23:36] "GET /api/v1/database/_info?q=(keys:!(permissions)) HTTP/1.1" 200 -
superset_app | 2021-02-02T03:23:36.377123020Z 172.17.0.233 - - [02/Feb/2021 03:23:36] "GET /static/assets/images/favicon.png HTTP/1.1" 200 -
superset_app | 2021-02-02T03:23:36.377136655Z INFO:werkzeug:172.17.0.233 - - [02/Feb/2021 03:23:36] "GET /static/assets/images/favicon.png HTTP/1.1" 200 -
superset_app | 2021-02-02T03:23:48.713990050Z DEBUG:superset.models.core:Database.get_sqla_engine(). Masked URL: clickhouse://gpsec:XXXXXXXXXX@10.200.xx.xx:8858/sec
superset_app | 2021-02-02T03:23:48.716697915Z DEBUG:superset.stats_logger:[stats_logger] (incr) DatabaseRestApi.test_connection.error
superset_app | 2021-02-02T03:23:48.716723303Z DEBUG:superset.stats_logger:[stats_logger] (timing) DatabaseRestApi.test_connection.time | 7.412515580654144
superset_app | 2021-02-02T03:23:48.717956405Z 172.17.0.233 - - [02/Feb/2021 03:23:48] "POST /api/v1/database/test_connection HTTP/1.1" 422 -
superset_app | 2021-02-02T03:23:48.717973565Z INFO:werkzeug:172.17.0.233 - - [02/Feb/2021 03:23:48] "POST /api/v1/database/test_connection HTTP/1.1" 422 -
what you expected to happen.
### Actual results
what actually happens.
#### Screenshots
If applicable, add screenshots to help explain your problem.
#### How to reproduce the bug
1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error
### Environment
(please complete the following information):
- superset version: `superset version`
- python version: `python --version`
- node.js version: `node -v`
### Checklist
Make sure to follow these steps before submitting your issue - thank you!
- [ ] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [ ] I have reproduced the issue with at least the latest released version of superset.
- [ ] I have checked the issue tracker for the same issue and I haven't found one similar.
### Additional context
Add any other context about the problem here.
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv commented on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv commented on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-776574545
@suedschwede thank for your help
I changed the clickhouse conf to :
```
clickhouse_db:
image: yandex/clickhouse-server:20.8
environment:
CLICKHOUSE_DB: my_database
ports:
- 9000:9000
- 8123:8123
```
I can connect from dbeaver without setting a user and password.
And this URI work in superset
> clickhouse://clickhouse_db:8123/my_database
@hodgesrm your solution work also when there is no defined user and password
> clickhouse://clickhouse_db/my_database
I will give a try to pip install infi.clickhouse_orm==1.0.4
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-776574545
----------------------------------------------------------------
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
[GitHub] [superset] hodgesrm commented on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
hodgesrm commented on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-776455126
Try leaving off the port. The ClickHouse SQLAlchemy driver uses native tcp connectivity and should connect to port 9000. If you leave it off the driver will do the right thing.
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-771978976
same for me , maybe sqlalchemy-clickhouse is not part of the docker image of dev
using the docker-compose of the repo for superset
```
superset/superset$ docker-compose up -d
```
and this clickhouse-server :
```
docker run --rm -e CLICKHOUSE_DB=my_database -e CLICKHOUSE_USER=username -e CLICKHOUSE_PASSWORD=password -p 9001:9000/tcp yandex/clickhouse-server
```
```
clickhouse://user:password@localhost:9001/my_database
```
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-772029397
With dbeaver it's working : jdbc:clickhouse://localhost:8123/my_database
but with superset :
```
clickhouse://username:password@localhost:8123/my_database
```
or
```
clickhouse://username:password@clickhouse_db:8123/my_database
```
don't work
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-772006646
Alright ! thank @nytai
by adding sqlalchemy-clickhouse inside superset/.docker/requirements-local.txt
but I still have error connecting to clickhouse, even when I add it to the docker-compose.yml of the repo
```
clickhouse_db:
image: yandex/clickhouse-server:20.8
environment:
CLICKHOUSE_DB: my_database
CLICKHOUSE_USER: username
CLICKHOUSE_PASSWORD: password
ports:
- 9001:9000
```
clickhouse://username:password@clickhouse_db:9000/my_database
```
DEBUG:superset.models.core:Database.get_sqla_engine(). Masked URL: clickhouse://username:XXXXXXXXXX@clickhouse_db:9000/my_databaseDEBUG:urllib3.connectionpool:Starting new HTTP connection (1): clickhouse_db:9000DEBUG:superset.stats_logger:[stats_logger] (incr) DatabaseRestApi.test_connection.errorDEBUG:superset.stats_logger:[stats_logger] (timing) DatabaseRestApi.test_connection.time | 11.717678004060872 172.19.0.1 - - [02/Feb/2021 21:33:04] "POST /api/v1/database/test_connection HTTP/1.1" 422 -INFO:werkzeug:172.19.0.1 - - [02/Feb/2021 21:33:04] "POST /api/v1/database/test_connection HTTP/1.1" 422 -
```
Any idee ? thank again
----------------------------------------------------------------
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
[GitHub] [superset] calipeng commented on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
calipeng commented on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-771358302
----------------------------------------------------------------
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
[GitHub] [superset] anilvpatel21 edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
anilvpatel21 edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-778374116
alt_hosts – list of alternative hosts for connection. Example: `clickhouse://username:password@host:port/database?alt_hosts=host1:port1,host2:port2`
It will assure that if the host is failing it will connect to the alternate host for the high availability.
As in Apache superset this parameters are not acceptable, may be it's a problem of sqlachemy-clickhouse driver.
Also I tried clickhouse-sqlachemy driver which depends on clickhouse-driver and the driver gets loaded and connection is established using TCP protocol, but somehow did not received acknowledgement. It also a problem of the driver here.
How to assure high availability of clickhouse database while connecting using superset?
8123 worked because it runs on the http protocol.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
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
[GitHub] [superset] Slach commented on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
Slach commented on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-903282793
@anilvpatel21 did you try to use https://github.com/vertamedia/chproxy with HTTP protocol?
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
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
[GitHub] [superset] anilvpatel21 edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
anilvpatel21 edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-778179439
Is there any way to connect with multiple hosts, as a clickhouse driver support alt_hosts as a parameters. Any help?
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-771978976
same for me , maybe **sqlalchemy-clickhouse** is not part of the docker image of dev
using the docker-compose of the repo for superset
```
superset/superset$ docker-compose up -d
```
and this clickhouse-server :
```
docker run --rm -e CLICKHOUSE_DB=my_database -e CLICKHOUSE_USER=username -e CLICKHOUSE_PASSWORD=password -p 9001:9000/tcp yandex/clickhouse-server:21.1.2
```
with this SQLALCHEMY URI :
```
clickhouse://username:password@localhost:9001/my_database
```
----------------------------------------------------------------
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
[GitHub] [superset] calipeng commented on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
calipeng commented on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-771358444
ClickHouse server version 20.9.3.45 (official build).
----------------------------------------------------------------
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
[GitHub] [superset] anilvpatel21 commented on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
anilvpatel21 commented on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-904685493
@Slach Thanks. Surely I will look into it. For now we used zookeeper and HAProxy for our systems.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
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
[GitHub] [superset] anilvpatel21 edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
anilvpatel21 edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-778374116
alt_hosts – list of alternative hosts for connection. Example: `clickhouse://username:password@host:port/database?alt_hosts=host1:port1,host2:port2`
It will assure that if the host is failing it will connect to the alternate host for the high availability.
As in Apache superset this parameters are not acceptable, its a problem of driver I used to connect clickhouse. (sqlachemy-clickhouse)
Also I tried clickhouse-sqlachemy driver which depends on clickhouse-driver and the driver gets loaded and connection is established using TCP protocol, but somehow did not received acknowledgement.
How to assure high availability of clickhouse database while connecting using superset?
8123 worked because it runs on the http protocol.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
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
[GitHub] [superset] raphaelauv commented on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv commented on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-771978976
----------------------------------------------------------------
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
[GitHub] [superset] anilvpatel21 edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
anilvpatel21 edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-778374116
alt_hosts – list of alternative hosts for connection. Example: `clickhouse://username:password@host:port/database?alt_hosts=host1:port1,host2:port2`
It will assure that if the host is failing it will connect to the alternate host for the high availability.
As in Apache superset the parameters are not acceptable, may be it's a problem of sqlachemy-clickhouse drive.
Also I tried clickhouse-sqlachemy driver which depends on clickhouse-driver and the driver gets loaded and connection is established using TCP protocol, but somehow did not received acknowledgement. It also a problem of the driver here.
How to assure high availability of clickhouse database while connecting using superset?
8123 worked because it runs on the http protocol.
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-771978976
same for me , maybe sqlalchemy-clickhouse is not part of the docker image of dev
using the docker-compose of the repo for superset
```
superset/superset$ docker-compose up -d
```
and this clickhouse-server :
```
docker run --rm -e CLICKHOUSE_DB=my_database -e CLICKHOUSE_USER=username -e CLICKHOUSE_PASSWORD=password -p 9001:9000/tcp yandex/clickhouse-server:21.1.2
```
with this SQLALCHEMY URI :
```
clickhouse://username:password@localhost:9001/my_database
```
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-772006646
Alright ! thank @nytai
by adding sqlalchemy-clickhouse inside superset/.docker/requirements-local.txt
but I still have error connecting to clickhouse, even when I add it to the docker-compose.yml of the repo
```
clickhouse_db:
image: yandex/clickhouse-server:20.8
environment:
CLICKHOUSE_DB: my_database
CLICKHOUSE_USER: username
CLICKHOUSE_PASSWORD: password
ports:
- 9001:9000
```
clickhouse://username:password@clickhouse_db:9000/my_database
```
DEBUG:superset.models.core:Database.get_sqla_engine(). Masked URL: clickhouse://username:XXXXXXXXXX@clickhouse_db:9000/my_database
DEBUG:urllib3.connectionpool:Starting new HTTP connection (1): clickhouse_db:9000
DEBUG:superset.stats_logger:[stats_logger] (incr) DatabaseRestApi.test_connection.error
DEBUG:superset.stats_logger:[stats_logger] (timing) DatabaseRestApi.test_connection.time | 11.717678004060872
172.19.0.1 - - [02/Feb/2021 21:33:04] "POST /api/v1/database/test_connection HTTP/1.1" 422 -
INFO:werkzeug:172.19.0.1 - - [02/Feb/2021 21:33:04] "POST /api/v1/database/test_connection HTTP/1.1" 422 -
```
Any idee ? thank again
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-771978976
same for me , maybe sqlalchemy-clickhouse is not part of the docker image of dev
using the docker-compose of the repo for superset
```
superset/superset$ docker-compose up -d
```
and this clickhouse-server :
```
docker run --rm -e CLICKHOUSE_DB=my_database -e CLICKHOUSE_USER=username -e CLICKHOUSE_PASSWORD=password -p 9001:9000/tcp yandex/clickhouse-server:21.1.2
```
with this SQLALCHEMY URI :
```
clickhouse://user:password@localhost:9001/my_database
```
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-771978976
same for me , maybe sqlalchemy-clickhouse is not part of the docker image of dev
using the docker-compose of the repo for superset and this clickhouse-server :
```
docker run --rm -e CLICKHOUSE_DB=my_database -e CLICKHOUSE_USER=username -e CLICKHOUSE_PASSWORD=password -p 9001:9000/tcp yandex/clickhouse-server
```
```
clickhouse://user:password@localhost:9001/my_database
```
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-772006646
Alright ! thank @nytai
by adding sqlalchemy-clickhouse inside superset/.docker/requirements-local.txt
but I still have error connecting to clickhouse, even when I add it to the docker-compose.yml of the repo
```yml
clickhouse_db:
image: yandex/clickhouse-server:20.8
environment:
CLICKHOUSE_DB: my_database
CLICKHOUSE_USER: username
CLICKHOUSE_PASSWORD: password
ports:
- 9001:9000
- 8123:8123
```
clickhouse://username:password@clickhouse_db:9000/my_database
```
DEBUG:superset.models.core:Database.get_sqla_engine(). Masked URL: clickhouse://username:XXXXXXXXXX@clickhouse_db:9000/my_database
DEBUG:urllib3.connectionpool:Starting new HTTP connection (1): clickhouse_db:9000
DEBUG:superset.stats_logger:[stats_logger] (incr) DatabaseRestApi.test_connection.error
DEBUG:superset.stats_logger:[stats_logger] (timing) DatabaseRestApi.test_connection.time | 11.717678004060872
172.19.0.1 - - [02/Feb/2021 21:33:04] "POST /api/v1/database/test_connection HTTP/1.1" 422 -
INFO:werkzeug:172.19.0.1 - - [02/Feb/2021 21:33:04] "POST /api/v1/database/test_connection HTTP/1.1" 422 -
```
Any idee ? thank again
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-776574545
@suedschwede thank for your help
I changed the clickhouse docker-compose configuration to :
```yml
clickhouse_db:
image: yandex/clickhouse-server:20.8
environment:
CLICKHOUSE_DB: my_database
ports:
- 9000:9000
- 8123:8123
```
I can connect from dbeaver without setting a user and password.
And this URI work in superset
> clickhouse://clickhouse_db:8123/my_database
@hodgesrm not providing the port also work when there is no defined user and password
> clickhouse://clickhouse_db/my_database
-----
I will give a try to pip install infi.clickhouse_orm==1.0.4
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-776574545
@suedschwede thank for your help
I changed the clickhouse conf to :
```docker
clickhouse_db:
image: yandex/clickhouse-server:20.8
environment:
CLICKHOUSE_DB: my_database
ports:
- 9000:9000
- 8123:8123
```
I can connect from dbeaver without setting a user and password.
And this URI work in superset
> clickhouse://clickhouse_db:8123/my_database
@hodgesrm your solution work also when there is no defined user and password
> clickhouse://clickhouse_db/my_database
I will give a try to pip install infi.clickhouse_orm==1.0.4
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-772029397
With dbeaver it's working :
jdbc:clickhouse://localhost:8123/my_database
but with superset :
clickhouse://username:password@localhost:8123/my_database
or
clickhouse://username:password@clickhouse_db:8123/my_database
don't work
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-772029397
With dbeaver it's working :
jdbc:clickhouse://localhost:8123/my_database
but with superset :
clickhouse://username:password@localhost:8123/my_database
or
clickhouse://username:password@clickhouse_db:8123/my_database
don't work
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-772006646
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-771978976
same for me , maybe **sqlalchemy-clickhouse** is not part of the docker image of dev
using the docker-compose of the repo for superset
```shell
superset/superset$ docker-compose up -d
```
and this clickhouse-server :
```shell
docker run --rm -e CLICKHOUSE_DB=my_database -e CLICKHOUSE_USER=username -e CLICKHOUSE_PASSWORD=password -p 9001:9000/tcp yandex/clickhouse-server:21.1.2
```
with this SQLALCHEMY URI :
```
clickhouse://username:password@localhost:9000/my_database
```
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-771978976
same for me , maybe **sqlalchemy-clickhouse** is not part of the docker image of dev
using the docker-compose of the repo for superset
```shell
superset/superset$ docker-compose up -d
```
and this clickhouse-server :
```shell
docker run --rm -e CLICKHOUSE_DB=my_database -e CLICKHOUSE_USER=username -e CLICKHOUSE_PASSWORD=password -p 9001:9000/tcp yandex/clickhouse-server:21.1.2
```
with this SQLALCHEMY URI :
```
clickhouse://username:password@localhost:9001/my_database
```
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-771978976
same for me , maybe sqlalchemy-clickhouse is not part of the docker image of dev
using the docker-compose of the repo for superset
```
superset/superset$ docker-compose up -d
```
and this clickhouse-server :
```
docker run --rm -e CLICKHOUSE_DB=my_database -e CLICKHOUSE_USER=username -e CLICKHOUSE_PASSWORD=password -p 9001:9000/tcp yandex/clickhouse-server
```
with this SQLALCHEMY URI :
```
clickhouse://user:password@localhost:9001/my_database
```
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-776574545
@suedschwede thank for your help
I changed the clickhouse conf to :
```yml
clickhouse_db:
image: yandex/clickhouse-server:20.8
environment:
CLICKHOUSE_DB: my_database
ports:
- 9000:9000
- 8123:8123
```
I can connect from dbeaver without setting a user and password.
And this URI work in superset
> clickhouse://clickhouse_db:8123/my_database
@hodgesrm not providing the port also work when there is no defined user and password
> clickhouse://clickhouse_db/my_database
I will give a try to pip install infi.clickhouse_orm==1.0.4
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv commented on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv commented on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-771978976
same for me , maybe sqlalchemy-clickhouse is not part of the docker image of dev
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv commented on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv commented on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-772029397
With dbeaver it's working :
jdbc:clickhouse://localhost:8123/my_database
but with superset :
clickhouse://user:password@localhost:8123/my_database
or
clickhouse://user:password@clickhouse_db:8123/my_database
don't work
----------------------------------------------------------------
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
[GitHub] [superset] anilvpatel21 commented on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
anilvpatel21 commented on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-778179439
Is there any way to connect with multiple hosts, as a clickhouse driver support alt_hosts are parameters. Any help?
----------------------------------------------------------------
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
[GitHub] [superset] anilvpatel21 edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
anilvpatel21 edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-778179439
Is there any way to connect with multiple hosts, as a clickhouse driver support alt_hosts as a parameters. Any help?
https://clickhouse-driver.readthedocs.io/en/latest/
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-772006646
Alright ! thank @nytai
by adding sqlalchemy-clickhouse inside superset/.docker/requirements-local.txt
but I still have error connecting to clickhouse, even when I add it to the docker-compose.yml of the repo
```
clickhouse_db:
image: yandex/clickhouse-server:20.8
environment:
CLICKHOUSE_DB: my_database
CLICKHOUSE_USER: username
CLICKHOUSE_PASSWORD: password
ports:
- 9001:9000
```
clickhouse://username:password@clickhouse_db:9000/my_database
```
DEBUG:superset.models.core:Database.get_sqla_engine(). Masked URL: clickhouse://username:XXXXXXXXXX@clickhouse_db:9000/my_database
DEBUG:urllib3.connectionpool:Starting new HTTP connection (1): clickhouse_db:9000
DEBUG:superset.stats_logger:[stats_logger] (incr) DatabaseRestApi.test_connection.error
DEBUG:superset.stats_logger:[stats_logger] (timing) DatabaseRestApi.test_connection.time | 11.717678004060872
172.19.0.1 - - [02/Feb/2021 21:33:04] "POST /api/v1/database/test_connection HTTP/1.1" 422 -
INFO:werkzeug:172.19.0.1 - - [02/Feb/2021 21:33:04] "POST /api/v1/database/test_connection HTTP/1.1" 422 -
```
Any idee ? thank again
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv commented on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv commented on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-772006646
Alright ! thank @nytai
by adding sqlalchemy-clickhouse inside superset/.docker/requirements-local.txt
but I still have error connecting to clickhouse, even when I add it to the docker-compose.yaml of the repo
```
clickhouse_db:
image: yandex/clickhouse-server:20.8
environment:
CLICKHOUSE_DB: my_database
CLICKHOUSE_USER: username
CLICKHOUSE_PASSWORD: password
ports:
- 9001:9000
```
clickhouse://username:password@clickhouse_db:9000/my_database
```
DEBUG:superset.models.core:Database.get_sqla_engine(). Masked URL: clickhouse://username:XXXXXXXXXX@clickhouse_db:9000/my_databaseDEBUG:urllib3.connectionpool:Starting new HTTP connection (1): clickhouse_db:9000DEBUG:superset.stats_logger:[stats_logger] (incr) DatabaseRestApi.test_connection.errorDEBUG:superset.stats_logger:[stats_logger] (timing) DatabaseRestApi.test_connection.time | 11.717678004060872 172.19.0.1 - - [02/Feb/2021 21:33:04] "POST /api/v1/database/test_connection HTTP/1.1" 422 -INFO:werkzeug:172.19.0.1 - - [02/Feb/2021 21:33:04] "POST /api/v1/database/test_connection HTTP/1.1" 422 -
```
Any idee ? thank again
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-772029397
With dbeaver it's working : jdbc:clickhouse://localhost:8123/my_database
but with superset theses URI :
```
clickhouse://username:password@localhost:8123/my_database
```
or
```
clickhouse://username:password@clickhouse_db:8123/my_database
```
don't work
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-772029397
With dbeaver it's working : jdbc:clickhouse://localhost:8123/my_database
but with superset :
clickhouse://username:password@localhost:8123/my_database
or
clickhouse://username:password@clickhouse_db:8123/my_database
don't work
----------------------------------------------------------------
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
[GitHub] [superset] nytai commented on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
nytai commented on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-772019965
Looks like you got past the missing driver error though. I suspect your connection string is wrong, are you sure it's not port `9001`? You could try to connect to your db outside of the superset context to make sure a connection is possible
----------------------------------------------------------------
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
[GitHub] [superset] suedschwede commented on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
suedschwede commented on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-776555589
If you use a password for the default user in clickhouse, you need a different infi.clickhouse_orm version
pip uninstall infi.clickhouse_orm
pip install infi.clickhouse_orm==1.0.4
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-772029397
With dbeaver it's working :
jdbc:clickhouse://localhost:8123/my_database
but with superset :
clickhouse://username:password@localhost:8123/my_database
or
clickhouse://username:password@clickhouse_db:8123/my_database
don't work
----------------------------------------------------------------
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
[GitHub] [superset] calipeng commented on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
calipeng commented on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-771358302
dba@noslt-db7:~/incubator-superset$ ./venv/bin/superset --version
Python 3.7.3
Flask 1.1.2
Werkzeug 1.0.1
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-772006646
Alright ! thank @nytai
by adding sqlalchemy-clickhouse inside superset/.docker/requirements-local.txt
but I still have error connecting to clickhouse, even when I add it to the docker-compose.yml of the repo
```
clickhouse_db:
image: yandex/clickhouse-server:20.8
environment:
CLICKHOUSE_DB: my_database
CLICKHOUSE_USER: username
CLICKHOUSE_PASSWORD: password
ports:
- 9001:9000
- 8123:8123
```
clickhouse://username:password@clickhouse_db:9000/my_database
```
DEBUG:superset.models.core:Database.get_sqla_engine(). Masked URL: clickhouse://username:XXXXXXXXXX@clickhouse_db:9000/my_database
DEBUG:urllib3.connectionpool:Starting new HTTP connection (1): clickhouse_db:9000
DEBUG:superset.stats_logger:[stats_logger] (incr) DatabaseRestApi.test_connection.error
DEBUG:superset.stats_logger:[stats_logger] (timing) DatabaseRestApi.test_connection.time | 11.717678004060872
172.19.0.1 - - [02/Feb/2021 21:33:04] "POST /api/v1/database/test_connection HTTP/1.1" 422 -
INFO:werkzeug:172.19.0.1 - - [02/Feb/2021 21:33:04] "POST /api/v1/database/test_connection HTTP/1.1" 422 -
```
Any idee ? thank again
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-776574545
@suedschwede thank for your help
I changed the clickhouse docker-compose configuration to :
```yml
clickhouse_db:
image: yandex/clickhouse-server:20.8
environment:
CLICKHOUSE_DB: my_database
ports:
- 9000:9000
- 8123:8123
```
I can connect from dbeaver without setting a user and password.
And this URI work in superset
> clickhouse://clickhouse_db:8123/my_database
@hodgesrm not providing the port also work when there is no defined user and password
> clickhouse://clickhouse_db/my_database
I will give a try to pip install infi.clickhouse_orm==1.0.4
----------------------------------------------------------------
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
[GitHub] [superset] nytai commented on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
nytai commented on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-771981709
There's info for how to add python db drivers in the docker docs
https://github.com/apache/superset/blob/676e0bb28211ec8e588abb8898924771d3dd6f32/docker/README.md#local-packages
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-771978976
----------------------------------------------------------------
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
[GitHub] [superset] nytai commented on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
nytai commented on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-771981709
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-771978976
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv commented on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv commented on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-778292622
@anilvpatel21 I dont understand your question and also what is the relation with superset :confused:
----------------------------------------------------------------
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
[GitHub] [superset] anilvpatel21 commented on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
anilvpatel21 commented on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-778374116
alt_hosts – list of alternative hosts for connection. Example: `clickhouse://username:password@host:port/database?alt_hosts=host1:port1,host2:port2`
It will assure that if the host is failing it will connect to the alternate host for the high availability.
As in Apache superset the parameters are not acceptable, may be it's a problem of sqlachemy-clickhouse drive.
Also I tried clickhouse-sqlachemy driver which depends on clickhouse-driver and the driver gets loaded and connection is established using TCP protocol, but somehow did not received acknowledgement. It also a problem of the driver here.
How to assure high availability of clickhouse database while connecting using superset?
----------------------------------------------------------------
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
[GitHub] [superset] raphaelauv edited a comment on issue #12881: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
Posted by GitBox <gi...@apache.org>.
raphaelauv edited a comment on issue #12881:
URL: https://github.com/apache/superset/issues/12881#issuecomment-778292622
@anilvpatel21 I don't understand your question and also what is the relation with superset :confused:
----------------------------------------------------------------
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