为了更快的定位您的问题，请提供以下信息，谢谢
【详述】创建了一个异步视图，但是视图一直没有数据
【背景】删除重建视图，设定查询超时时间，修改同步间隔，修改同步起始日期
【创建脚本】
USE zzz;
CREATE MATERIALIZED VIEW dws_trade_all_plat_category_mv
DISTRIBUTED BY HASH(project_id)
REFRESH ASYNC START(‘2021-09-01 10:00:00’) EVERY (interval 60 SECOND)
AS
SELECT *
FROM zzz.trade;
【业务影响】构建用户宽表，基础业务受到严重影响
【StarRocks版本】3.0.4 f8ff06d
【集群规模】1fe+3be（fe与be混部）
【机器信息】48C/64G/万兆
【联系方式】2464222685@qq.com
【附件】
上面是实际的物化视图创建语句么？物化视图的base表是sr内表么？物化视图创建语句发一下，物化视图创建后 show materialized views where name=‘customer_mv’\G;结果请发下
CREATE MATERIALIZED VIEW dws_trade_all_plat_category_mv
DISTRIBUTED BY HASH(project_id)
REFRESH ASYNC START(“2021-09-01 10:00:00”) EVERY(INTERVAL 60 SECOND)
PROPERTIES (
“replication_num” = “2”,
“replicated_storage” = “true”,
“storage_medium” = “HDD”
)
AS SELECT trade.id, trade.trade_no, trade.trade_type, trade.parent_id, trade.paymentmethod, trade.paymentmethod_key, trade.pay_state, trade.acc_id, trade.acc_type, trade.child_acc_id, trade.relation_acc_id, trade.currency, trade.amount, trade.detail_count, trade.pay_type, trade.channel, trade.trade_channel, trade.customer_channel, trade.third_trade_no, trade.return_url, trade.create_time, trade.pay_time, trade.donation_name, trade.donation_mobile, trade.invoice_id, trade.is_anonymous, trade.is_online, trade.user_remark, trade.subject, trade.remark, trade.tenant_id, trade.custom_parameter, trade.title, trade.is_del, trade.project_type, trade.project_id, trade.project_categoryid, trade.project_title, trade.project_photo, trade.project_areacode, trade.project_execute_orgid, trade.project_execute_orgname, trade.project_manage_orgid, trade.project_manage_orgname, trade.user_type, trade.user_id, trade.user_name, trade.user_photo, trade.user_mobile, trade.user_nickname, trade.user_areacode, trade.user_sex, trade.user_age, trade.IP, trade.user_agent, trade.coordinates, trade.openid, trade.chain_code, trade.chain_time
FROM zzz.trade;
物化视图的select语句单独执行有结果么？没能复现。创建成功
show materialized views where name=‘customer_mv’\G;结果发下
mv中提取的query单独跑，需要多久？
可以尝试 调大query_timeout试试
set global query_timeout=3600