1、Clickhouse Too many partitions for single INSERT block (more than xxx) 解决方法
Too many partitions for single INSERT block (more than 100)
The limit is controlled by 'max_partitions_per_insert_block' setting.
Large number of partitions is a common misconception.
原因：
clickhouse 要求每次写入的数据不能跨越特别多的 partitions，具体受参数 max_partitions_per_insert_block 控制，调整该参数即可。
解决方法：修改配置文件/etc/clickhouse-server/users.xml，加入如下配置
<max_partitions_per_insert_block>5000</max_partitions_per_insert_block>