CHECK MIGRATION 语法用于校验数据迁移作业中的数据一致性。
CheckMigration ::=
'CHECK' 'MIGRATION' migrationJobId ('BY' algorithmDefinition)?
migrationJobId ::=
integer | identifier | string
algorithmDefinition ::=
'TYPE' '(' 'NAME' '=' migrationCheckAlgorithmType (',' propertiesDefinition)? ')'
migrationCheckAlgorithmType ::=
string
propertiesDefinition ::=
'PROPERTIES' '(' (key '=' value (',' key '=' value)*)? ')'
key ::=
string
value ::=
literal
migrationJobId 需要通过 SHOW MIGRATION LIST 语法查询获得
指定 BY 子句时,migrationCheckAlgorithmType 需要通过 SHOW MIGRATION CHECK ALGORITHMS 语法查询获得
CHECK MIGRATION 'j01016e501b498ed1bdb2c373a2e85e2529a6' BY TYPE (NAME='CRC32_MATCH');
CHECK、MIGRATION、BY、TYPE、NAME、PROPERTIES
