v.18.1Improvement

Skipped Rows Due to Parsing Errors Logged in Server

Official CH changelog text
If some rows were skipped during an insert due to parsing errors (this is possible with the input_allow_errors_num and input_allow_errors_ratio settings enabled), the number of skipped rows is now written to the server log (Leonardo Cecchi).
ClickHouse now logs the number of rows skipped during an INSERT operation when parsing errors occur and are allowed by the input_allow_errors_num or input_allow_errors_ratio settings.

Why it matters

This feature helps users monitor and diagnose data ingestion issues by providing visibility into how many rows were ignored due to parsing errors during data insertion, improving transparency and debugging capability.

How to use it

Enable row skipping on parsing errors by setting input_allow_errors_num or input_allow_errors_ratio to a non-zero value, then perform data inserts as usual. The count of skipped rows will be automatically written to the ClickHouse server log.

Related resources

PreviousNext