admin show frontend config like "history_job_keep_max_second";
+-----------------------------+------------+-------+------+-----------+---------+
| Key                         | AliasNames | Value | Type | IsMutable | Comment |
+-----------------------------+------------+-------+------+-----------+---------+
| history_job_keep_max_second | []         | 60    | int  | true      |         |
+-----------------------------+------------+-------+------+-----------+---------+
1 row in set (0.01 sec)

CREATE TABLE `set_bucket_num_tbl` ( `k1`  date, `k2`  datetime, `k3`  char(20), `k4`  varchar(20), `k5`  boolean, `k6`  tinyint, `k7`  smallint, `k8`  int, `k9`  bigint, `k10` largeint, `k11` float, `k12` double, `k13` decimal(27,9) ) DUPLICATE KEY(`k1`, `k2`, `k3`, `k4`, `k5`) COMMENT "OLAP" DISTRIBUTED BY HASH(`k1`) BUCKETS 3 PROPERTIES ( "replication_num" = "3", "storage_format" = "v2", "light_schema_change" = "false" );
CREATE TABLE `set_hash_to_random_tbl` ( `k1`  date, `k2`  datetime, `k3`  char(20), `k4`  varchar(20), `k5`  boolean, `k6`  tinyint, `k7`  smallint, `k8`  int, `k9`  bigint, `k10` largeint, `k11` float, `k12` double, `k13` decimal(27,9) ) DUPLICATE KEY(`k1`, `k2`, `k3`, `k4`, `k5`) COMMENT "OLAP" DISTRIBUTED BY HASH(`k1`) BUCKETS 3 PROPERTIES ( "replication_num" = "3", "storage_format" = "v2", "light_schema_change" = "false" );
alter table set_bucket_num_tbl DISTRIBUTED BY HASH(`k1`) buckets 2;
alter table set_hash_to_random_tbl distributed by random;

SHOW ALTER TABLE optimize;

mysql> SHOW ALTER TABLE optimize;
+-------+------------------------+---------------------+---------------------+-----------------------------------------+---------------+----------+------+----------+---------+
| JobId | TableName              | CreateTime          | FinishTime          | Operation                               | TransactionId | State    | Msg  | Progress | Timeout |
+-------+------------------------+---------------------+---------------------+-----------------------------------------+---------------+----------+------+----------+---------+
| 11002 | set_bucket_num_tbl     | 2024-05-13 19:59:55 | 2024-05-13 20:00:11 | ALTER DISTRIBUTED BY HASH(k1) BUCKETS 2 | 1003          | FINISHED |      | 100      | 86400   |
| 11014 | set_hash_to_random_tbl | 2024-05-13 20:00:02 | NULL                | ALTER DISTRIBUTED BY RANDOM             | 1005          | RUNNING  |      | 0        | 86400   |
+-------+------------------------+---------------------+---------------------+-----------------------------------------+---------------+----------+------+----------+---------+
2 rows in set (0.00 sec)

wait until result is null
mysql> SHOW ALTER TABLE optimize;
Empty set (0.01 sec)

mysql> alter system create image;
Query OK, 0 rows affected (0.01 sec)


grep -iar "checkpoint finished save image"  fe.log