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: The name of the corresponding table (In the case of multiple tables, since it is a dynamic table, the specific table name is not displayed, and we uniformly display it as "multi-table").
           IsMultiTbl: Indicates whether it is a multi-table
               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 5 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

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;
```
Show the currently running routine import job named test1
```
SHOW ROUTINE LOAD FOR test1;
```
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;
```
Display all running routine import jobs under example_db
```
use example_db;
SHOW ROUTINE LOAD;
```
Display the currently running routine import job named test1 under example_db
```
SHOW ROUTINE LOAD FOR example_db.test1;
```
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

SHOW-ROLES SHOW-ROUTINE-LOAD-TASK