ClickHouse-Native-JDBC icon indicating copy to clipboard operation
ClickHouse-Native-JDBC copied to clipboard

when to support max_partitions_per_insert_block??

Open JasonDung opened this issue 5 years ago • 1 comments

I need to partition by multiple fields and must have the max_partitions_per_insert_block property. Otherwise, the data will not be inserted

JasonDung avatar Apr 01 '21 11:04 JasonDung

You can following below code to define settings which not pre-defined in SettingKey https://github.com/housepower/ClickHouse-Native-JDBC/blob/28d65bffeadef76b0504ef65c08d20f31ec881a0/clickhouse-native-jdbc/src/test/java/com/github/housepower/settings/ClickHouseConfigTest.java#L80

Are you using Spark to insert data? If yes, consider repartition your DataFrame to match the clickhouse Table partition before write.

pan3793 avatar Apr 01 '21 15:04 pan3793