CANCEL DDL stops a DDL job in the RUNNING or PAUSED state, rolls back all changes, and restores the table to its state before the job ran.
Prerequisites
Run SHOW DDL to get the JOB_ID of the job to cancel.
Syntax
CANCEL DDL JOB_ID;Example
CANCEL DDL 1359628009396502528;
Query OK, 1 row affected (0.03 sec)