SHOW-ROUTINE-LOAD

Name

SHOW ROUTINE LOAD

Description

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

grammar:

1. SHOW [ALL] ROUTINE LOAD [FOR jobName];

Result description:

1. Id: job ID
2. Name: job name
3. CreateTime: job creation time
4. PauseTime: The last job pause time
5. EndTime: Job end time
6. DbName: corresponding database name
7. TableName: corresponding table name
8. State: job running state
9. DataSourceType: Data source type: KAFKA
10. CurrentTaskNum: The current number of subtasks
11. JobProperties: Job configuration details
12. DataSourceProperties: Data source configuration details
13. CustomProperties: custom configuration
14. Statistic: Job running status statistics
15. Progress: job running progress
16. Lag: job delay status
17. ReasonOfStateChanged: The reason for the job state change
18. ErrorLogUrls: The viewing address of the filtered unqualified data
19. OtherMsg: other error messages
  • State

1. There are the following 4 states: 2. * NEED_SCHEDULE: The job is waiting to be scheduled 3. * RUNNING: The job is running 4. * PAUSED: The job is paused 5. * STOPPED: The job has ended 6. * CANCELLED: The job was canceled - Progress

1. 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

1. 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.

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

1. 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.

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

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

1. 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.

1. SHOW ALL ROUTINE LOAD FOR example_db.test1;

Keywords

1. SHOW, ROUTINE, LOAD

Best Practice