Skip to main content
Version: Latest-3.2

CANCEL EXPORT

Description​

Cancels a given data unloading job. Unloading jobs with the state CANCELLED or FINISHED cannot be canceled. Canceling an unloading job is an asynchronous process. You can use the SHOW EXPORT statement to check whether an unloading job is successfully canceled. The unloading job is successfully canceled if the value of State is CANCELLED.

The CANCEL EXPORT statement requires that you have at least one of the following privileges on the database to which the given unloading job belongs: SELECT_PRIV, LOAD_PRIV, ALTER_PRIV, CREATE_PRIV, DROP_PRIV, and USAGE_PRIV. For more information about privilege descriptions, see GRANT.

Syntax​

CANCEL EXPORT
[FROM db_name]
WHERE QUERYID = "query_id"

Parameters​

ParameterRequiredDescription
db_nameNoThe name of the databases to which the unloading job belongs. If this parameter is not specified, an unloading job in your current database is canceled.
query_idYesThe query ID of the unloading job. You can obtain the ID by using the LAST_QUERY_ID() function. Note that this function only returns the latest query ID.

Examples​

Example 1: Cancel an unloading job whose query ID is 921d8f80-7c9d-11eb-9342-acde48001121 in the current database.

CANCEL EXPORT
WHERE queryid = "921d8f80-7c9d-11eb-9342-acde48001121";

Example 2: Cancel an unloading job whose query ID is 921d8f80-7c9d-11eb-9342-acde48001121 in the example_db database.

CANCEL EXPORT 
FROM example_db 
WHERE queryid = "921d8f80-7c9d-11eb-9342-acde48001122";