ALTER LOAD
Description
Changes the priority of a Broker Load job that is in the QUEUEING or LOADING state. This statement is supported since v2.5.
NOTE
Changing the priority of a Broker Load job that is in the LOADING state does not affect the execution of the job.
Syntax
ALTER LOAD FOR <label_name>
properties
(
'priority'='{LOWEST | LOW | NORMAL | HIGH | HIGHEST}'
)
Parameters
Parameter | Required | Description |
---|---|---|
label_name | Yes | The label of the load job. Format: [<database_name>.]<label_name> . See BROKER LOAD. |
priority | Yes | The new priority that you want to specify for the load job. Valid values: LOWEST , LOW , NORMAL , HIGH , and HIGHEST . See BROKER LOAD. |
Examples
Suppose that you have a Broker Load job whose label is test_db.label1
and the job is in the QUEUEING state. If you want to run the job at the soonest, you can run the following command to change the priority of the job to HIGHEST
:
ALTER LOAD FOR test_db.label1
properties
(
'priority'='HIGHEST'
);