CANCEL IMPORT

April 23, 2025 · View on GitHub

The CANCEL IMPORT statement is used to cancel a data import job created in TiDB.

Required privileges

To cancel a data import job, you need to be the creator of the import job or have the SUPER privilege.

CancelImportJobsStmt ::=
    'CANCEL' 'IMPORT' 'JOB' JobID

To cancel an import job with the ID as 1, execute the following statement:

CANCEL IMPORT JOB 1;

The output is as follows:

Query OK, 0 rows affected (0.01 sec)

This statement is a TiDB extension to MySQL syntax.