SHOW ROUTINE LOAD

description

1. This statement is used to show the running status of the Routine Load job
2. grammar:
3. SHOW [ALL] ROUTINE LOAD [FOR jobName];

5. Result description:

7. Id: Job ID
8. Name: job name
9. CreateTime: Job creation time
10. PauseTime: Last job pause time
11. EndTime: The end time of the job
12. DbName: corresponding database name
13. TableName: Corresponding table name
14. State: job running status
15. DataSourceType: Data source type: KAFKA
16. CurrentTaskNum: current number of subtasks
17. 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: Reason of job status change ErrorLogUrls: The viewing address of the filtered data with unqualified quality OtherMsg: Other error messages

1. * State

3. There are the following 4 states:

5. * NEED_SCHEDULE: The job is waiting to be scheduled
6. * RUNNING: The job is running
7. * PAUSED: The job is suspended
8. * STOPPED: The job has ended
9. * CANCELLED: The job has been cancelled

11. * Progress

13. For Kafka data sources, the offset currently consumed by each partition is displayed. For example, {"0":"2"} means that the consumption progress of Kafka partition 0 is 2.

15. * Lag

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

example

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

SHOW ALL ROUTINE LOAD FOR test1;

  1. Show the current running routine import job named test1

SHOW ROUTINE LOAD FOR test1;

  1. Display all routine import jobs (including stopped or cancelled jobs) under example_db. The result is one or more lines.

use example_db; SHOW ALL ROUTINE LOAD;

  1. Display all running routine import jobs under example_db

use example_db; SHOW ROUTINE LOAD;

  1. Display the current running routine import job named test1 under example_db

SHOW ROUTINE LOAD FOR example_db.test1;

  1. Display all routine import jobs named test1 (including stopped or cancelled jobs) under example_db. The result is one or more lines.

SHOW ALL ROUTINE LOAD FOR example_db.test1;

keyword

SHOW,ROUTINE,LOAD