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