更新时间:2025-08-13 GMT+08:00
ClickHouse数据迁移过程报错
问题现象
执行ClickHouse集群内数据迁移,数据迁移失败,提示报错信息:
<Error> ClusterCopier: Will retry: Code: 62, e.displayText() = DB::Exception: Syntax error (Query): failed at position 122 ('000001677E49EA7C'): 000001677E49EA7C')' AS partition_key)) AND (1 = 1) LIMIT 1. Expected one of: IN, AND, OR, alias, NOT, AS, IS, token, Comma, BETWEEN, ILIKE, LIKE, comma or closing bracket, NOT LIKE, NOT ILIKE, NOT IN, GLOBAL IN, GLOBAL NOT IN, MOD, DIV, QuestionMark, Stack trace (when copying this message, always include the lines below)
原因分析
迁移的目标表,分区键采用PARTITION BY (date_p, app_key),partition_key是这种元组形式的,数据迁移任务在配置copier任务的时候上传到ZooKeeper上的description配置里面给partition加了引号,导致数据迁移失败。
父主题: 使用ClickHouse