ClickHouse / ClickHouse/ClickHouse

INSERT INTO FUNCTION cluster IN JOIN table

Open
#32,963 7 comments 0 reactions 0 assignees View on GitHub
comp-distributed external question
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.