Getting Duplicates in Clickhouse clustering

Question

I have started clustering environment on clickhouse.

I have started with the basic two shard and one replica configuration using distrbuted table concept.

When i am executing the query on distributed table i am getting the duplicate values.

i.e. if i have 43 rows i am getting result as 86.

Can anyone please help how to solve this duplicates problem..

Please find my config.xml file settings below. I have used same settings in both of my clickhouse servers

<http_port>8123</http_port>
    <tcp_port>9000</tcp_port>
<remote_servers>
    <perftest_3shards_1replicas>
        <shard>
            <replica>
                <host>192.168.0.132</host>
                <port>9000</port>
            </replica>
        </shard>
        <shard>
            <replica>
                <host>192.168.0.184</host>
                <port>9000</port>
            </replica>
        </shard>
        <shard>
    </perftest_3shards_1replicas>
</remote_servers>

i met same issue, i found its caused by two cluster with same name! (//∇//)\ — toien
– toien, Commented Aug 21, 2020 at 11:48

Ivan Blinkov · Accepted Answer · 2018-08-09 14:48:29Z

3

As far as I understood, you have just put same data to each shard instead of splitting the data between shards.

answered Aug 9, 2018 at 14:48

Ivan Blinkov

2,57417 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting Duplicates in Clickhouse clustering

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related