CHECK MIGRATION
Description
The CHECK MIGRATION syntax is used to check data consistency in migration job.
Syntax
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 ::=
literalSupplement
-
migrationJobIdneeds to be obtained through SHOW MIGRATION LIST syntax query -
When the
BYclause is specified,migrationCheckAlgorithmTypeneeds to be obtained through SHOW MIGRATION CHECK ALGORITHMS syntax query
Example
- Check data consistency in migration job
CHECK MIGRATION 'j01016e501b498ed1bdb2c373a2e85e2529a6' BY TYPE (NAME='CRC32_MATCH');Reserved word
CHECK, MIGRATION, BY, TYPE, NAME, PROPERTIES