flinksql读取kafka数据写入ck，报错：IOException: Attempt to Flush ClickHouse executor failed

详细报错日志如下：

java.io.IOException: Attempt to Flush ClickHouse executor failed, exhausted retry times = 3

at org.apache.flink.connector.clickhouse.internal.AbstractClickHouseOutputFormat.attemptFlush(AbstractClickHouseOutputFormat.java:99) ~[flink-connector-clickhouse-1.12.0.jar:?]

at org.apache.flink.connector.clickhouse.internal.ClickHouseBatchOutputFormat.flush(ClickHouseBatchOutputFormat.java:93) ~[flink-connector-clickhouse-1.12.0.jar:?]

at org.apache.flink.connector.clickhouse.internal.ClickHouseBatchOutputFormat.writeRecord(ClickHouseBatchOutputFormat.java:83) ~[flink-connector-clickhouse-1.12.0.jar:?]

at org.apache.flink.connector.clickhouse.internal.ClickHouseBatchOutputFormat.writeRecord(ClickHouseBatchOutputFormat.java:24) ~[flink-connector-clickhouse-1.12.0.jar:?]

at org.apache.flink.streaming.api.functions.sink.OutputFormatSinkFunction.invoke(OutputFormatSinkFunction.java:87) ~[flink-dist_2.11-1.12.4.jar:1.12.4]

at org.apache.flink.streaming.api.functions.sink.SinkFunction.invoke(SinkFunction.java:49) ~[flink-dist_2.11-1.12.4.jar:1.12.4]

at org.apache.flink.table.runtime.operators.sink.SinkOperator.processElement(SinkOperator.java:72) ~[flink-table-blink_2.11-1.12.4.jar:1.12.4]

at org.apache.flink.streaming.runtime.tasks.CopyingChainingOutput.pushToOperator(CopyingChainingOutput.java:71) ~[flink-dist_2.11-1.12.4.jar:1.12.4]

at org.apache.flink.streaming.runtime.tasks.CopyingChainingOutput.collect(CopyingChainingOutput.java:46) ~[flink-dist_2.11-1.12.4.jar:1.12.4]

at org.apache.flink.streaming.runtime.tasks.CopyingChainingOutput.collect(CopyingChainingOutput.java:26) ~[flink-dist_2.11-1.12.4.jar:1.12.4]

at org.apache.flink.streaming.api.operators.CountingOutput.collect(CountingOutput.java:50) ~[flink-dist_2.11-1.12.4.jar:1.12.4]

at org.apache.flink.streaming.api.operators.CountingOutput.collect(CountingOutput.java:28) ~[flink-dist_2.11-1.12.4.jar:1.12.4]

at StreamExecCalc$57.processElement(Unknown Source) ~[?:?]

需求：streamx 平台 读取 kafka 数据写入 Clickhouse。

ck 中的字段：
device_id UInt64 COMMENT '设备id',
 

insert into tpl_im_mec_vehicle_base_local_2
select
    1 as source,-- 待确定，非必须字段设置为默认值
    -1 as device_id,
from ogl_ivis_tfc_partcp_rt_kafka
;

分析：当 ck 中的字段类型为 无符号整型（UInt）时，范围为 0-**，不能设置为 小于 0 的整数。

解决：

insert into tpl_im_mec_vehicle_base_local_2

select
    1 as source,-- 待确定，非必须字段设置为默认值
    1 as device_id,
from ogl_ivis_tfc_partcp_rt_kafka
;