异步物化视图按照月分区创建后，数据不全，只能查到一些分区数据

[andyhdic]

CREATE MATERIALIZED VIEW mv_electronic_back_order_detail_market_order_market
COMMENT ‘菜场-按照每月计算销售额和销售量’
DISTRIBUTED BY HASH(co_3)
REFRESH ASYNC
START (‘2025-01-23 12:12:00’)
EVERY (INTERVAL 1 HOUR)
Properties (
‘excluded_trigger_tables’=‘t_market’,
‘excluded_refresh_tables’=‘t_market’
)
PARTITION BY co_3
AS
SELECT
date_trunc(“month”, ta_0.record_time) AS co_3,
ta_1.market_name AS co_6,
sum(ta_0.order_total_price)

FROM `market_new_dw`.`t_electronic_back_order_detail_market` AS `ta_2`
    INNER JOIN `market_new_dw`.`t_market` AS `ta_1` ON `ta_2`.`market_id` = `ta_1`.`id`
    INNER JOIN `market_new_dw`.`t_electronic_back_order_market` AS `ta_0` ON `ta_2`.`order_code` = `ta_0`.`order_code`
GROUP BY  date_trunc("month", `ta_0`.`record_time`),	
    `ta_1`.`market_name`
  ;

这是sql,只能查看2010-2022但是 2023 2024 2025没有，

[andyhdic]

基表有数据，但是没有生效

[dongquan]

基表数据是刚导入完成么，这里没有统计到2023和2024分区的数据

可以关闭物化视图改写，确认下创建物化视图的查询语句执行是否可以查询到数据。```
select * from information_schema.tasks where DEFINITION like “%视图名称%” order by CREATE_TIME desc limit 1;