<ul><li>High cardinality partitions can be useful for achieving fast, deduplicated reads and improving query performance.</li><li>Inserting data into highly-partitioned tables can be complex and result in a large number of parts.</li><li>Inserting data in order of the partition key can mitigate the issue of a large number of parts.</li><li>Another approach is to insert records into an unpartitioned table first and then insert them into the partitioned table.</li></ul>

ClickHouse — optimizing bulk inserts for partitioned tables

Discover more