CANCEL LOAD

Description

This statement is used to cancel the load job of the specified label or cancel the load jobs in batch through fuzzy matching.

CANCEL LOAD
[FROM db_name]
WHERE [LABEL = "load_label" | LABEL like "label_pattern"];

Example

1. Cancel the load job labelled as example_db_test_load_label on the database example_db

   CANCEL LOAD
   FROM example_db
   WHERE LABEL = "example_db_test_load_label";

2. Cancel the load jobs containing example_ on database example_db.

   CANCEL LOAD
   FROM example_db
   WHERE LABEL like "example_";

Keywords

CANCEL, LOAD

Best Practices

1. Only load jobs in PENDING, ETL, LOADING status that have not been completed yet can be cancelled.
2. When executing cancel in batch, Palo will not guarantee that all corresponding load jobs can be cancelled. That is, it is possible that only some load jobs can be cancelled successfully. Users can view the job status by using SHOW LOAD statement and try to repeat the execution of CANCEL LOAD statement.