ClickHouse data insert

[sadik...@gmail.com]

Hi All,

when I loading data into Table using text file, if one error record found in the file, upload stop from that row.

is it possible to continue loading while rejecting the error record and sending error record into a separate log?

command used

for i in /datan2/process/TBL_SUBSCRIBER/x* ; do echo $i; cat $i |clickhouse-client --host=172.99.99.99 --query="INSERT INTO db1.TBL_SUBSCRIBER FORMAT CSV";done;

Regards,

sadika

[tatiana....@revjet.com]

There are settings to control that:
input_format_allow_errors_num

input_format_allow_errors_ratio

They both must be set to values above zero.

Unfortunately they are documented only in Russian.

[sadik...@gmail.com]

Thanks