AFAIK ClickHouse no longer sucks at joins and is actually quite good. https://clickhouse.com/blog/clickhouse-fast-joins