RESUME ROUTINE LOAD
Description
Resumes a Routine load job. The job will temporarily enter NEED_SCHEDULE state because the job is being re-scheduled. And after some time, the job will be resumed to RUNNING state, continuing consuming messages from the data source and loading data. You can check the job's information using the SHOW ROUTINE LOAD statement.
You can manage Routine Load jobs that run on StarRocks tables only as a user who has the INSERT privilege on those StarRocks tables. If you do not have the INSERT privilege, follow the instructions provided in GRANT to grant the INSERT privilege to the user that you use to connect to your StarRocks cluster.
Syntax
RESUME ROUTINE LOAD FOR [db_name.]<job_name>
Parameters
Parameter | Required | Description |
---|---|---|
db_name | The name of the database to which the Routine Load job belongs. | |
job_name | ✅ | The name of the Routine Load job. |
Examples
Resume the Routine Load job example_tbl1_ordertest1
in the database example_db
.
RESUME ROUTINE LOAD FOR example_db.example_tbl1_ordertest1;