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

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