versioned_docs/version-2.0/sql-manual/sql-reference/Show-Statements/SHOW-ROUTINE-LOAD-TASK.md

{ “title”: “SHOW-ROUTINE-LOAD-TASK”, “language”: “en” }

SHOW-ROUTINE-LOAD-TASK

Name

SHOW ROUTINE LOAD TASK

Description

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

SHOW ROUTINE LOAD TASK
WHERE JobName = "job_name";

The returned results are 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: The unique ID of the subtask.
TxnId: The import transaction ID corresponding to the subtask.
TxnStatus: The import transaction status corresponding to the subtask. When TxnStatus is null, it means that the subtask has not yet started scheduling.
JobId: The job ID corresponding to the subtask.
CreateTime: The creation time of the subtask.
ExecuteStartTime: The time when the subtask is scheduled to be executed, usually later than the creation time.
Timeout: Subtask timeout, usually twice the max_batch_interval set by the job.
BeId: The ID of the BE node executing this subtask.
DataSourceProperties: The starting offset of the Kafka Partition that the subtask is ready to consume. is a Json format string. Key is Partition Id. Value is the starting offset of consumption.

Example

Display the subtask information of the routine import task named test1.
```
SHOW ROUTINE LOAD TASK WHERE JobName = "test1";
```

Keywords

SHOW, ROUTINE, LOAD, TASK

Best Practice

With this command, you can view how many subtasks are currently running in a Routine Load job, and which BE node is running on.