This question shows research effort; it is useful and clear
2


During a reload of a replicated MySQL database to Clickhouse, using "clickhouse-mysql" I run into the "Too many partitions for single INSERT block" and I seem unable to progress.

So far, some of the things I've tried:

setting "max_partitions_per_insert_block" to ZERO, to see if it would get through.
using --mempool-max-rows to 5000, 10.000 and 20.000, so that it skips the 100.000 default loading
using PARTITION BY toYYYYMMDD(created) when creating th