ClickHouse / ClickHouse/ClickHouse
INSERT INTO FUNCTION cluster IN JOIN table
- Dominant language
- C++
- Stars
- 49.9k
- Forks
- 9k
- Avg merge
- 21h 32m
- Merged PRs (30d)
- 515
Description
Clickhouse 21.8.12.29.
Cluster of 2 shards with 2 replicas
I'm trying to INSERT data into table with ENGING=Join. My aim is to get similar data on all replicas.
Data INSERTS as SELECT from table with ENGINE=Distributed over ReplicatedMergeTree:
```
INSERT INTO FUNCTION cluster('my_clusters', 'tmp', 'test_table')
SELECT column1, column2
FROM db.table_with_distributed_engine;
```
As far as I'm not setting sharding key (I don't need join table to be sharded) I'm getting error:
`Code: 55, e.displayText() = DB::Exception: Method write is not supported by storage Distributed with more than one shard and no sharding key provided (version 21.8.12.29 (official build))`
But I'm expecting to get full copied of data on all shards.
Contributor guide
Assessment
This issue has not been assessed yet.