CANCEL DISTRIBUTION JOB New in v9.0.0

The CANCEL DISTRIBUTION JOB statement is used to cancel a Region scheduling task created using the DISTRIBUTE TABLE statement in TiDB.

Synopsis

CancelDistributionJobsStmt ::=
    'CANCEL' 'DISTRIBUTION' 'JOB' JobID

Examples

The following example cancels the distribution job with ID 1:

CANCEL DISTRIBUTION JOB 1;

The output is as follows:

Query OK, 0 rows affected (0.01 sec)

MySQL compatibility

This statement is a TiDB extension to MySQL syntax.

See also

• DISTRIBUTE TABLE
• SHOW DISTRIBUTION JOBS