CANCEL-EXPORT

Name

SinceVersion dev

CANCEL EXPORT

Description

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

  1. CANCEL EXPORT 
  2. [FROM db_name]
  3. WHERE [LABEL = "export_label" | LABEL like "label_pattern" | STATE = "PENDING/EXPORTING"]

Example

  1. Cancel the export job whose label is example_db_test_export_label on the database example_db

    1. CANCEL EXPORT
    2. FROM example_db
    3. WHERE LABEL = "example_db_test_export_label";

  2. Cancel all export jobs containing example _on the database example_db.

    1. CANCEL EXPORT
    2. FROM example_db
    3. WHERE LABEL like "%example%";

  3. Cancel all export jobs which state are “PENDING”

    1. CANCEL EXPORT
    2. FROM example_db
    3. WHERE STATE = "PENDING";

Keywords

  1.  CANCEL, EXPORT

Best Practice

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