[Materialized View] Query transparent mv: Cannot invoke "com.starrocks.catalog.Function.functionName()" because the return value of "com.starrocks.analysis.FunctionCallExpr.getFn()" is null

[zarah1]

版本 3.4.0 存算一体部署
创建物化视图时增加where 条件，物化视图创建成功，查询物化视图返回 Cannot invoke "com.starrocks.catalog.Function.functionName()" because the return value of "com.starrocks.analysis.FunctionCallExpr.getFn()" is null

查询物化视图刷新状态，物化视图上一次刷新的状态 SUCCESS

查询物化视图分区

查询物化视图sql

创建物化视图sql
CREATE MATERIALIZED VIEW adx.adx_saas_offline_stat_day_async_mv01 PARTITION BY data_date DISTRIBUTED BY HASH(pkg,media_id) BUCKETS 3 REFRESH ASYNC START('2025-01-29 22:00:00') EVERY (interval 1 day) PROPERTIES( "session.enable_spill" = "true", "session.spill_mode" = "force", "partition_refresh_number" = "1", "storage_medium" = "SSD", "storage_cooldown_ttl" = "10 DAY", "resource_group" = "rg1", "transparent_mv_rewrite_mode" = "true" ) AS SELECT date_trunc('day', data_date) data_date, dsp_id, target_id, media_id, posid_id, pkg, country, platform, style, instl, rewarded, publisher_id, cluster_name, media_slot_id, sum(ssp_req) ssp_req, sum(dsp_req) dsp_req, sum(dsp_fill_req) dsp_fill_req, sum(dsp_win) dsp_win, sum(ssp_win) ssp_win, sum(dsp_floor) dsp_floor, sum(ssp_floor) ssp_floor, sum(dsp_win_price) dsp_win_price, sum(imp) imp, sum(clk) clk, sum(revenue) revenue, sum(cost) cost from adx.adx_saas_offline_stat_hi where data_date < timestamp(CURDATE()) group by date_trunc('day', data_date), dsp_id, target_id, media_id, posid_id, pkg, country, platform, style, instl, rewarded, publisher_id, cluster_name, media_slot_id

[LiShuMing]

Thanks for your feedbacks.

1. This should be because transparent_mv_rewrite_mode='true' property, you can disable it first to walk aroud.
2. Can you find more exception stack and give more reproduce DDLs(mv and the base table), let me check it?