v.21.6Improvement
Enable DateTime64 as Version Column in ReplacingMergeTree
EnableDateTime64to be a version column inReplacingMergeTree. #23992 (kevin wan).
Why it matters
The feature allows users to use high-precision timestamps with theDateTime64 type for versioning in ReplacingMergeTree tables, improving the granularity and accuracy of version control for data deduplication and replacement.How to use it
Define aReplacingMergeTree table and specify a DateTime64 column as the version column in the table's sorting key or version field. This enables the table to distinguish versions based on DateTime64 values during merges.