[Question] ReplicatedMergeTree can't insert duplicate rows ?

[lamberken]

Hi, ReplicatedMergeTree can't insert duplicate rows? what's wrong?

a minimal reproducible example

DROP TABLE IF EXISTS test.replicated_alter1;

CREATE TABLE test.replicated_alter1
(
    d Date,
    k UInt64,
    i32 Int32
)
ENGINE = ReplicatedMergeTree('/clickhouse/tables/test/alter', 'r1', d, k, 8192);

INSERT INTO test.replicated_alter1 VALUES ('2015-01-03', 10, 44);
INSERT INTO test.replicated_alter1 VALUES ('2015-01-03', 10, 44);


SELECT *
FROM test.replicated_alter1 ;


┌──────────d─┬──k─┬─i32─┐
│ 2015-01-03 │ 10 │  44 │
└────────────┴────┴─────┘

[lamberken]

@alexey-milovidov, hi, can you help me, thank you.

[lamberken]

It's similar to #827. how to solve it now. thanks.
I understand why it was designed. my solution is each row has a uuid column.

Whether or not the parameter can also be achieved?

[zhang2014]

Maybe check insert_deduplicate setting

[lamberken]

@zhang2014 💯