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";