Skip to main content
Version: 3.2

load_tracking_logs

load_tracking_logs provides error logs of load jobs. This view is supported from StarRocks v3.0 onwards.

The following fields are provided in load_tracking_logs:

FieldDescription
JOB_IDThe ID of the load job.
LABELThe label of the load job.
DATABASE_NAMEThe database that the load job belongs to.
TRACKING_LOGErrors (if any) of the load job.
tip

To query the view load_tracking_logs you will need to filter on either a JOB_ID or a LABEL.

You can retrieve the JOB_ID or LABEL of a load job from the view information_schema.loads.

Example:

SELECT * from information_schema.load_tracking_logs WHERE label ='user_behavior'\G
*************************** 1. row ***************************
JOB_ID: 10141
LABEL: user_behavior
DATABASE_NAME: mydatabase
TRACKING_LOG: NULL
TYPE: BROKER
1 row in set (0.02 sec)