[Subtask]: Supports Http interface for getting details of optimizing tasks

[wangtaohz]

Search before asking

• I have searched in the issues and found no similar issues.

Description

The tasks are the most important part for the detail page of optimizing process.

We should support Http interface to get tasks of an optimizing process, which should support page and pageSize.

All the information of tasks are stored in the table task_runtime of sysdb

CREATE TABLE `task_runtime` (
  `process_id` bigint(20) NOT NULL,
  `task_id` int(11) NOT NULL,
  `retry_num` int(11) DEFAULT NULL COMMENT 'Retry times',
  `table_id` bigint(20) NOT NULL,
  `partition_data` varchar(128) DEFAULT NULL COMMENT 'Partition data',
  `create_time` timestamp NULL DEFAULT NULL COMMENT 'Task create time',
  `start_time` timestamp NULL DEFAULT NULL COMMENT 'Time when task start waiting to execute',
  `end_time` timestamp NULL DEFAULT NULL COMMENT 'Time when task finished',
  `cost_time` bigint(20) DEFAULT NULL,
  `status` varchar(16) DEFAULT NULL COMMENT 'Optimize Status: PLANNED, SCHEDULED, ACKED, FAILED, SUCCESS, CANCELED',
  `fail_reason` varchar(4096) DEFAULT NULL COMMENT 'Error message after task failed',
  `optimizer_token` varchar(50) DEFAULT NULL COMMENT 'Job type',
  `thread_id` int(11) DEFAULT NULL COMMENT 'Job id',
  `rewrite_output` longblob COMMENT 'rewrite files output',
  `metrics_summary` text COMMENT 'metrics summary',
  `properties` mediumtext COMMENT 'task properties',
  PRIMARY KEY (`process_id`,`task_id`),
  KEY `table_index` (`table_id`,`process_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Optimize task basic information'

This issue is related to #2115

Parent issue

#2114

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct