|
|
|
|
|
|
by hodgesrm
1385 days ago
|
|
|
To pile on your answer a bit the manual bucketing you describe is exactly how ClickHouse works in most cases. It won't allow joins / IN on multiple distributed tables--i.e., sharded/replicated tables--unless you explicitly set a property called distributed_product_mode. [0] This is to prevent you from shooting yourself in the foot either by bad performance or improperly distributed data. This constraint will eventually be relaxed but most apps are able to work around it just fine. The ones that can't use Snowflake. [0] https://clickhouse.com/docs/en/operations/settings/settings/... |
|
|