CANCEL LOAD

Description

Cancels a given load job. A load job in one of the following situations cannot be canceled:

• The state is CANCELLED or FINISHED.
• The transaction has been committed.

Canceling a load job is an asynchronous process. You can use the SHOW LOAD statement to check whether a load job is successfully canceled. The load job is successfully canceled if the value of State is CANCELLED and the value of type (displayed in ErrorMsg) is USER_CANCEL.

Syntax

CANCEL LOAD
[FROM db_name]
WHERE LABEL = "label_name";

Parameters

Examples

Example 1: Cancel the load job whose label is example_label in the current database.

CANCEL LOAD
WHERE LABEL = "example_label";

Example 2: Cancel the load job whose label is example_label in the example_db database.

CANCEL LOAD
FROM example_db
WHERE LABEL = "example_label";