Skip to main content
Version: 2.5

STOP ROUTINE LOAD

Description

Stops a Routine Load job.

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.

::: warning

  • A stopped Routine Load job cannot be resumed. Therefore, please proceed with caution when executing this statement.
  • If you only need to pause the Routine Load job, you can execute PAUSE ROUTINE LOAD.

:::

Syntax

STOP ROUTINE LOAD FOR [db_name.]<job_name>

Parameters

ParameterRequiredDescription
db_nameThe name of the database to which the Routine Load job belongs.
job_nameThe name of the Routine Load job.

Examples

Stop the Routine Load job example_tbl1_ordertest1 in the database example_db.

STOP ROUTINE LOAD FOR example_db.example_tbl1_ordertest1;