The CHECK MIGRATION syntax is used to check data consistency in migration job.
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 needs to be obtained through SHOW MIGRATION LIST syntax query
When the BY clause is specified, migrationCheckAlgorithmType needs to be obtained through SHOW MIGRATION CHECK ALGORITHMS syntax query
CHECK MIGRATION 'j01016e501b498ed1bdb2c373a2e85e2529a6' BY TYPE (NAME='CRC32_MATCH');
CHECK, MIGRATION, BY, TYPE, NAME, PROPERTIES