SHOW ROUTINE LOAD TASK

Description

View the subtasks of a specified Routine Load job currently running .

SHOW ROUTINE LOAD TASK
WHERE JobName = "job_name";

The return result is as follows:

              TaskId: d67ce537f1be4b86-abf47530b79ab8e6
               TxnId: 4
           TxnStatus: UNKNOWN
               JobId: 10280
          CreateTime: 2020-12-12 20:29:48
    ExecuteStartTime: 2020-12-12 20:29:48
             Timeout: 20
                BeId: 10002
DataSourceProperties: {"0":19}

• TaskId：Unique ID of subtask.
• TxnId：Load job ID corresponding to subtask.
• TxnStatus：Load job status corresponding to subtask, generally UNKNOWN, with no practical meaning.
• JobId：Job ID corresponding to the subtask.
• CreateTime：The time wehn the subtask was created.
• ExecuteStartTime：the time when the subtask is scheduled for execution, generally later than the create time.
• Timeout：Timeout period of subtasks, usually two times of MaxIntervalS set in job.
• BeId：ID of BE node this subtask is running on.
• DataSourceProperties：Start offset of Kafka Partition that to be consumed by subtask. It is a string in Json format. Key is Partition Id. Value is the start offset consumed.

Example

1. Show subtask information of routine load task named test1.

   SHOW ROUTINE LOAD TASK WHERE JobName = "job";

Keywords

SHOW, ROUTINE, LOAD, TASK

Best Practices

The number of subtasks of a Routine Load job currently running and the specific BE node they are running on can be viewed by using this command.