详细报错日志如下:
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_base_local_2
select
1 as source,-- 待确定,非必须字段设置为默认值
-1 as device_id,
from ogl_rt_kafka
;
分析:当 ck 中的字段类型为 无符号整型(UInt)时,范围为 0-**,不能设置为 小于 0 的整数。
解决:
insert into tpl_base_local_2
select
1 as source,-- 待确定,非必须字段设置为默认值
1 as device_id,
from ogl_rt_kafka
;