Use input function to replace large batch insert sql to improve performance

FrankChen021 / bithon

An observability platform mainly for Java

Apache License 2.0

14 stars 4 forks source link

Use input function to replace large batch insert sql to improve performance #660

Closed FrankChen021 closed 9 months ago

FrankChen021 commented 9 months ago

See: https://clickhouse.com/docs/en/integrations/java#insert-1

FrankChen021 commented 9 months ago

Using of input indeed improves the performance, but it introduces inconvenience if schema changes. ClickHouse strictly requires the number of columns in the schema matches the number of columns in the INSERT.