CANCEL-LOAD

Name

CANCEL LOAD

Description

This statement is used to undo an import job for the specified label. Or batch undo import jobs via fuzzy matching

  1. CANCEL LOAD
  2. [FROM db_name]
  3. WHERE [LABEL = "load_label" | LABEL like "label_pattern" | STATE = "PENDING/ETL/LOADING"]

Notice: Cancel by State is supported since 1.2.0.

Example

  1. Cancel the import job whose label is example_db_test_load_label on the database example_db

    1. CANCEL LOAD
    2. FROM example_db
    3. WHERE LABEL = "example_db_test_load_label";
  2. Cancel all import jobs containing example _on the database example_db.

    1. CANCEL LOAD
    2. FROM example_db
    3. WHERE LABEL like "example_";

SinceVersion 1.2.0

  1. Cancel all import jobs which state are “LOADING”

    1. CANCEL LOAD
    2. FROM example_db
    3. WHERE STATE = "loading";

Keywords

  1. CANCEL, LOAD

Best Practice

  1. Only pending import jobs in PENDING, ETL, LOADING state can be canceled.
  2. When performing batch undo, Doris does not guarantee the atomic undo of all corresponding import jobs. That is, it is possible that only some of the import jobs were successfully undone. The user can view the job status through the SHOW LOAD statement and try to execute the CANCEL LOAD statement repeatedly.