ETL中写入数据到Clickhouse抛出 Code: 27. DB::ParsingException: Cannot parse input

原因：

目标字段的长度和精度不足以容纳源字段

解决办法：

将目标字段的长度和精度提高，或者降低源字段的长度与精度

示例1：源是timestamp，目标是date：

Caused by: ru.yandex.clickhouse.except.ClickHouseUnknownException: ClickHouse exception, code: 1002, host: 10.10.110.33, port: 31824; Code: 27. DB::ParsingException: Cannot parse input: expected '\n' before: ' 17:47:36\n': 
Row 1:
Column 0,   name: c1, type: Nullable(Date), parsed text: "2024-02-20"
ERROR: garbage after Nullable(Date): " 17:47:36<LINE FEED>"

: While executing ParallelParsingBlockInputFormat: (at row 1)
. (CANNOT_PARSE_INPUT_ASSERTION_FAILED) (version 22.8.9.24 (official build))

........

Caused by: java.lang.Throwable: Code: 27. DB::ParsingException: Cannot parse input: expected '\n' before: ' 17:47:36\n': 

规避：创建目标表的时候选择高精度的字段类型

示例2：源是带有小数的，目标是整数：

Caused by: smartbix.datamining.engine.execute.exception.ExecuteException: org.apache.spark.SparkException: Job aborted due to stage failure: Task 0 in stage 4315.0 failed 1 times, most recent failure: Lost task 0.0 in stage 4315.0 (TID 3600) (smartbi-engine-experiment-v11 executor driver): ru.yandex.clickhouse.except.ClickHouseUnknownException: ClickHouse exception, code: 1002, host: 10.10.110.33, port: 31824; Code: 27. DB::ParsingException: Cannot parse input: expected '\n' before: '.11111\n': 
Row 1:
Column 0,   name: c1, type: Nullable(Int32), parsed text: "1111"
ERROR: garbage after Nullable(Int32): ".11111<LINE FEED>"

: While executing ParallelParsingBlockInputFormat: (at row 1)
. (CANNOT_PARSE_INPUT_ASSERTION_FAILED)

......

Caused by: java.lang.Throwable: Code: 27. DB::ParsingException: Cannot parse input: expected '\n' before: '.11111\n': 


规避：
建表使用更高精度的浮点数