News for hackers. Stuff that matters.
Re:Solving duplicate data with performant deduplication by higeorge13 on Friday November 24, 2023 @03:08PM (#38407669)
I believe there are 0 people working with CH and ReplacingMergeTree and don’t know that they have to use final or group by in order to get non duplicate data. It’s mentioned in the table engine page, their knowledge base everywhere.

Also i have not recently seen anyone not recommending it. It might have been the case a few years ago, but performance of final has improved and it’s faster than alternatives. People suggest to use MergeTrees obviously but if no alternative, replacing is the way to go.

There are no comments on this comment yet.