SHOW ROUTINE LOAD

    There are the following 4 states:
    * NEED_SCHEDULE: The job is waiting to be scheduled
    * PAUSED: The job is suspended
    * STOPPED: The job has ended
    * CANCELLED: The job has been cancelled
    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.
    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.

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

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

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,ROUTINE,LOAD