MySQL [(none)]> use test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MySQL [test]> drop materialized view order_mv;
Query OK, 0 rows affected (0.00 sec)

MySQL [test]> CREATE MATERIALIZED VIEW order_mv DISTRIBUTED BY HASH(`order_id`) REFRESH ASYNC START('2023-09-01 10:00:00') EVERY (interval 1 day) AS SELECT     order_list.order_id,     sum(goods.price) as total FROM order_list INNER JOIN goods ON goods.item_id1 = order_list.item_id2 GROUP BY order_id;
Query OK, 0 rows affected (0.13 sec)

MySQL [test]> select * from information_schema.tasks  order by CREATE_TIME desc;
+-----------+---------------------+--------------------------------------------------+-----------------+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+--------------------------------------------------+------------+
| TASK_NAME | CREATE_TIME         | SCHEDULE                                         | CATALOG         | DATABASE | DEFINITION                                                                                                                                                                                                                                                         | EXPIRE_TIME | PROPERTIES                                       | CREATOR    |
+-----------+---------------------+--------------------------------------------------+-----------------+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+--------------------------------------------------+------------+
| mv-19667  | 2025-12-18 22:29:30 | PERIODICAL START(2023-09-01T10:00) EVERY(1 DAYS) | default_catalog | test     | insert overwrite `order_mv` SELECT `test`.`order_list`.`order_id`, sum(`test`.`goods`.`price`) AS `total`
FROM `test`.`order_list` INNER JOIN `test`.`goods` ON `test`.`goods`.`item_id1` = `test`.`order_list`.`item_id2`
GROUP BY `test`.`order_list`.`order_id` | NULL        | ('mvId'='19667','warehouse'='default_warehouse') | 'root'@'%' |
+-----------+---------------------+--------------------------------------------------+-----------------+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+--------------------------------------------------+------------+
1 row in set (0.01 sec)