You can execute the PAUSE DDL statement to suspend a DDL job that is in the RUNNING or ROLLBACK_RUNNING state.

Syntax

PAUSE DDL JOB_ID;
Note You can execute the SHOW DDL statement to obtain the value of the JOB_ID parameter.

Examples

PAUSE DDL 1359630950316638208;
Query OK, 1 row affected (0.04 sec)

- Execute the following statement again:
SHOW DDL\G;
*************************** 1. row ***************************
           JOB_ID: 1359630950316638208
    OBJECT_SCHEMA: d2
      OBJECT_NAME: t1
           ENGINE: DAG
         DDL_TYPE: CREATE_TABLE
            STATE: PAUSED
         PROGRESS: 0%
       START_TIME: 2021-08-04 14:02:19.781
         END_TIME: 2021-08-04 14:02:35.276
 ELAPSED_TIME(MS): 15495
      PHY_PROCESS: 
BACKFILL_PROGRESS: 0%
1 row in set (0.02 sec)