SHOW ROUTINE LOAD TASK
Descriptionβ
This syntax is used to view the currently running subtasks of a specified Routine Load job.
Syntaxβ
SHOW ROUTINE LOAD TASK WHERE JobName = <job_name>;
Required Parametersβ
1. <job_name>
The name of the routine load job to view.
Return Resultsβ
The return results include the following fields:
| Field Name | Description |
|---|---|
| TaskId | Unique ID of the subtask |
| TxnId | Import transaction ID corresponding to the subtask |
| TxnStatus | Import transaction status of the subtask. Null indicates the subtask has not yet been scheduled |
| JobId | Job ID corresponding to the subtask |
| CreateTime | Creation time of the subtask |
| ExecuteStartTime | Time when the subtask was scheduled for execution, typically later than creation time |
| Timeout | Subtask timeout, typically twice the max_batch_interval set in the job |
| BeId | BE node ID executing this subtask |
| DataSourceProperties | Starting offset of Kafka Partition that the subtask is preparing to consume. It's a Json format string. Key is Partition Id, Value is the starting offset for consumption |
Access Control Requirementsβ
Users executing this SQL command must have at least the following privileges:
| Privilege | Object | Notes |
|---|---|---|
| LOAD_PRIV | Table | SHOW ROUTINE LOAD TASK requires LOAD privilege on the table |
Notesβ
- A null TxnStatus doesn't indicate task error, it may mean the task hasn't been scheduled yet
- The offset information in DataSourceProperties can be used to track data consumption progress
- When Timeout is reached, the task will automatically end regardless of whether data consumption is complete
Examplesβ
-
Show subtask information for a routine load task named test1.
SHOW ROUTINE LOAD TASK WHERE JobName = "test1";
