Skip to main content
Skip to main content

SHOW-ROUTINE-LOAD

SHOW-ROUTINE-LOAD​

Name​

SHOW ROUTINE LOAD

Description​

This statement is used to display the running status of the Routine Load job

grammar:

SHOW [ALL] ROUTINE LOAD [FOR jobName];

Result description:

                  Id: job ID
Name: job name
CreateTime: job creation time
PauseTime: The last job pause time
EndTime: Job end time
DbName: corresponding database name
TableName: corresponding table name
State: job running state
DataSourceType: Data source type: KAFKA
CurrentTaskNum: The current number of subtasks
JobProperties: Job configuration details
DataSourceProperties: Data source configuration details
CustomProperties: custom configuration
Statistic: Job running status statistics
Progress: job running progress
Lag: job delay status
ReasonOfStateChanged: The reason for the job state change
ErrorLogUrls: The viewing address of the filtered unqualified data
OtherMsg: other error messages
  • State

    There are the following 4 states:
    * NEED_SCHEDULE: The job is waiting to be scheduled
    * RUNNING: The job is running
    * PAUSED: The job is paused
    * STOPPED: The job has ended
    * CANCELLED: The job was canceled
  • Progress

    For Kafka data sources, displays the currently consumed offset for each partition. For example, {"0":"2"} indicates that the consumption progress of Kafka partition 0 is 2.

*Lag

  For Kafka data sources, shows the consumption latency of each partition. For example, {"0":10} means that the consumption delay of Kafka partition 0 is 10.

Example​

  1. Show all routine import jobs named test1 (including stopped or canceled jobs). The result is one or more lines.

    SHOW ALL ROUTINE LOAD FOR test1;
  2. Show the currently running routine import job named test1

    SHOW ROUTINE LOAD FOR test1;
  3. Display all routine import jobs (including stopped or canceled jobs) under example_db. The result is one or more lines.

    use example_db;
    SHOW ALL ROUTINE LOAD;
  4. Display all running routine import jobs under example_db

    use example_db;
    SHOW ROUTINE LOAD;
  5. Display the currently running routine import job named test1 under example_db

    SHOW ROUTINE LOAD FOR example_db.test1;
  6. Displays all routine import jobs named test1 under example_db (including stopped or canceled jobs). The result is one or more lines.

    SHOW ALL ROUTINE LOAD FOR example_db.test1;

Keywords​

SHOW, ROUTINE, LOAD

Best Practice​