Support for clickhouse cluster in superset - alt_hosts

[royxact]

Can you please add support for alt_hosts in the superset connection string?

Thanks

[genzgd]

What does that mean? The clickhouse clients don't have support for falling back to other hosts.

[royxact]

Hi @genzgd !
It's a parameter found in the clickhouse python driver https://clickhouse-driver.readthedocs.io/en/latest/api.html
Also the go driver has it.
So I thought it makes sense to support it here as well.
Thanks

[genzgd]

Ah, I understand. Just to clarify, this works in superset with clickhouse-driver?

In any case, I think that makes this a duplicate of #74?

[royxact]

Correct, seems a similar requirement. With alt_hosts behavior, you try the host, and if it doesn't respond you go the alternative. So it's more of a fail over rather than a load balancer.

…

On Mon, Jan 6, 2025, 14:36 Geoff Genz ***@***.***> wrote: Ah, I understand. Just to clarify, this works in superset with clickhouse-driver? In any case, I think that makes this a duplicate of #74 <#74>? — Reply to this email directly, view it on GitHub <#447 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACS2WLAKSSP3RAEET3UWEDD2JJ2D3AVCNFSM6AAAAABUVGK7FKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDKNZTGAZDKNRSGE> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[EinavDanielDX]

I can confirm that this functionality works in Superset using the ClickHouse driver, configured with the following connection string:
clickhouse+native://CH_USER:CH_PASSWORD@CH_HOST:9000/CH_DB?alt_hosts=CH_ALT_HOST:9000

However, we need to use ClickHouse Connect for other reasons, so it would be great if you could support this feature.

[vanu-k]

@EinavDanielDX tells about reasons. Why do you need to use ClickHouse Connect? What are benefits?

[waleed-dawood]

+1