Superset connectivity with clickhouse

[sanjaypocket52]

How to connect clickhouse with superset clickhouse://default@IP:9000/data_lake

It is gave me below error
ERROR: Could not load database driver: clickhouse

while i have installed pip install clickhouse-sqlalchemy

[pesto93]

Did you figure it out? I am having same problem here.

[anilvpatel21]

I need to restart the superset. Do you know how to connect with multiple hosts?

[Teeeto]

I had no luck with clickhouse-jdbc driver
However clickhouse4j worked like a charm
https://github.com/blynkkk/clickhouse4j
The URL should be like clickhouse+native://default@host/database

[Mehdi-YC]

well , it works but not that fine , you can not get data from your views , it returns no rows

[Slach]

@SAVE-POlNT could you share SQL query which show "no rows" for you?
Do you use some complex data types like enum, multi dimensional arrays or nested?

[Mehdi-YC]

no i just partitionnedemy table and quueried with select * from table_name in chart interface

[Slach]

could you share DESCRIBE your_db.table_name; results?

[Mehdi-YC]

im sorry , my ssh died yesterday , so i lost my data , basically i had 2 columns , it was a test database one of them was Decimal10(3)
and im pretty sure the problem was from it the other oner was only a String and worked for other tables

the 2nd problem is when i partition any table , i get only the first partition back when i query or want to add them to raw records chart

[l10178]

I get the same error, but when I refresh the pages, the database has been added and it works!

[Mehdi-YC]

do you get all the rows in graph explorer ?
i partitioned my table by date , and im getting only the first partition back as result

[l10178]

Yes, I got all.