CANCEL WARM UP
Descriptionβ
For terminating a specified warm-up job in Doris.
Syntaxβ
CANCEL WARM UP JOB WHERE id = <id>;
Required Parametersβ
The id of the warm-up job you want to terminate, which can be queried through the command
SHOW WARM UP JOB.
Permission Controlβ
The user executing this SQL command must have at least ADMIN_PRIV permissions.
Exampleβ
Query the warm-up jobs currently running in the system through SHOW WARM UP JOB:
SHOW WARM UP JOB
Its result is:
+----------------+---------------+---------+-------+-------------------------+-------------+----------+------------+--------+
| JobId | ClusterName | Status | Type | CreateTime | FinishBatch | AllBatch | FinishTime | ErrMsg |
+----------------+---------------+---------+-------+-------------------------+-------------+----------+------------+--------+
| 90290165739458 | CloudCluster1 | RUNNING | TABLE | 2024-11-11 11:11:42.700 | 1 | 3 | NULL | |
+----------------+---------------+---------+-------+-------------------------+-------------+----------+------------+--------+
Then terminate it through CANCEL WARM UP:
CANCEL WARM UP WHERE id = 90290165739458;
If the following content is returned, it indicates that the warm-up job corresponding to the specified id does not exist:
ERROR 1105 (HY000): errCode = 2, detailMessage = job id: 110 does not exist.
After a successful return, SHOW WARM UP JOB can be used again to see that the job status has changed from RUNNING to CANCELLED:
+----------------+---------------+-----------+-------+-------------------------+-------------+----------+-------------------------+-------------+
| JobId | ClusterName | Status | Type | CreateTime | FinishBatch | AllBatch | FinishTime | ErrMsg |
+----------------+---------------+-----------+-------+-------------------------+-------------+----------+-------------------------+-------------+
| 90290165739458 | CloudCluster1 | CANCELLED | TABLE | 2024-11-11 11:11:42.700 | 1 | 3 | 2024-11-11 11:11:43.700 | user cancel |
+----------------+---------------+-----------+-------+-------------------------+-------------+----------+-------------------------+-------------+
