CalvinKirs opened a new pull request, #34109:
URL: https://github.com/apache/doris/pull/34109
## Changes
### Task metadata add jobName
```sql
mysql> desc function tasks("type"="insert");;
+---------------+------+------+-------+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+------+------+-------+---------+-------+
| TaskId | TEXT | No | false | NULL | NONE |
| JobId | TEXT | No | false | NULL | NONE |
| JobName | TEXT | No | false | NULL | NONE |
| Label | TEXT | No | false | NULL | NONE |
| Status | TEXT | No | false | NULL | NONE |
| ErrorMsg | TEXT | No | false | NULL | NONE |
| CreateTime | TEXT | No | false | NULL | NONE |
| FinishTime | TEXT | No | false | NULL | NONE |
| TrackingUrl | TEXT | No | false | NULL | NONE |
| LoadStatistic | TEXT | No | false | NULL | NONE |
| User | TEXT | No | false | NULL | NONE |
+---------------+------+------+-------+---------+-------+
11 row
```
### Failed tasks cannot be displayed.
We use a LoadManager to store task execution information, but failed tasks
are not stored. Since the entire lifecycle of a task includes the Load Manager,
it must be managed throughout the entire Job Manager.
### Job metadata add succeedCount, failedCount, canceledCount
```sql
mysql> desc function jobs("type"="insert");
+-------------------+------+------+-------+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+------+------+-------+---------+-------+
| Id | TEXT | No | false | NULL | NONE |
| Name | TEXT | No | false | NULL | NONE |
| Definer | TEXT | No | false | NULL | NONE |
| ExecuteType | TEXT | No | false | NULL | NONE |
| RecurringStrategy | TEXT | No | false | NULL | NONE |
| Status | TEXT | No | false | NULL | NONE |
| ExecuteSql | TEXT | No | false | NULL | NONE |
| CreateTime | TEXT | No | false | NULL | NONE |
| SucceedTaskCount | TEXT | No | false | NULL | NONE |
| FailedTaskCount | TEXT | No | false | NULL | NONE |
| CanceledTaskCount | TEXT | No | false | NULL | NONE |
| Comment | TEXT | No | false | NULL | NONE |
+-------------------+------+------+-------+---------+-------+
12 rows in set (0.01 sec)
```
We have added the fields SucceedTaskCount, FailedTaskCount,
RunningTaskCount, and CancelTaskCount. Users want to be able to view the
execution status of tasks, so we included these fields.
## Compatibility:
### Upgrade
Upgrading smoothly without any compatibility issues.
### Rollback
However, if you upgrade to this new version and then roll back to the old
version, the new version's tasks will not be displayed. The new version
deprecates the old task storage method, and the old tasks will be migrated to
the new task storage. Therefore, when rolling back to the old version, the
tasks generated by the new version will not be visible. However, tasks are
primarily responsible for task execution and have a short lifespan, so it will
not have a significant impact on users.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
