SHOW ROUTINE LOAD TASK
Description
Shows the execution information of load tasks within a Routine Load job.
note
For the relationship between a Routine Load job and the load tasks in it, see Load data using Routine Load
Syntax
SHOW ROUTINE LOAD TASK
[ FROM <db_name>]
[ WHERE JobName = <job_name> ]
note
You can add the \G option to the statement (such as SHOW ROUTINE LOAD TASK WHERE JobName = <job_name>\G) to vertically display the return result rather than in the usual horizontal table format.
Parameters
| Parameter | Required | Description |
|---|---|---|
| db_name | No | The name of the database to which the Routine Load job belongs. |
| JobName | No | The name of the Routine Load job. |
Output
| Parameter | Description |
|---|---|
| TaskId | The globally unique ID of the load task, automatically generated by StarRocks. |
| TxnId | The ID of the transaction to which the load task belongs. |
| TxnStatus | The status of the transaction to which the load task belongs. UNKNOWN indicates that the transaction is not started yet, possibly because the load task is not dispatched or executed. |
| JobId | The ID of the load job. |
| CreateTime | The date and time when the load task was created. |
| LastScheduledTime | The date and time when the load task was last scheduled. |
| ExecuteStartTime | The date and time when the load task was executed. |
| Timeout | The timeout period for the load task, controlled by the FE parameter routine_load_task_timeout_second and the task_timeout_second parameter in job_properties for the Routine Load job. |
| BeId | The ID of the BE that executes the load task. |
| DataSourceProperties | The load task's progress (measured in the offset) of consuming messages in partitions of the topic. |
| Message | The information returned for the load task, including task error information. |
Examples
View all load tasks in the Routine Load job example_tbl_ordertest.
MySQL [example_db]> SHOW ROUTINE LOAD TASK WHERE JobName = "example_tbl_ordertest";
+--------------------------------------+-------+-----------+-------+---------------------+---------------------+------------------+---------+------+------------------------------------+-----------------------------------------------------------------------------+
| TaskId | TxnId | TxnStatus | JobId | CreateTime | LastScheduledTime | ExecuteStartTime | Timeout | BeId | DataSourceProperties | Message |
+--------------------------------------+-------+-----------+-------+---------------------+---------------------+------------------+---------+------+------------------------------------+-----------------------------------------------------------------------------+
| abde6998-c19a-43d6-b48c-6ca7e14144a3 | -1 | UNKNOWN | 10208 | 2023-12-22 12:46:10 | 2023-12-22 12:47:00 | NULL | 60 | -1 | Progress:{"0":6},LatestOffset:null | there is no new data in kafka/pulsar, wait for 10 seconds to schedule again |
+--------------------------------------+-------+-----------+-------+---------------------+---------------------+------------------+---------+------+------------------------------------+-----------------------------------------------------------------------------+
1 row in set (0.00 sec)