CANCEL LOAD
Description
Cancels a given load job: Broker Load, Spark Load, or INSERT. A load job in the PREPARED, CANCELLED or FINISHED state cannot be canceled.
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
| Parameter | Required | Description |
|---|---|---|
| db_name | No | The name of the database to which the load job belongs. If this parameter is not specified, a load job in your current database is canceled by default. |
| label_name | Yes | The label of the load job. |
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";