页面历史

...

异常产生的原因：目标字段的长度和精度不足以容纳源字段

解决方法：将目标字段的长度和精度提高，或者降低源字段的长度与精度

示例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))

...