REPLACE WITH后异步物化视图实效

Viewed 6

原表muyun_service_log有物化视图:

CREATE MATERIALIZED VIEW v_base_muyun_service_log_view (collecttime,source_id,scene_id,system_id,asset_id,cnt) BUILD IMMEDIATE REFRESH AUTO ON SCHEDULE EVERY 1 MINUTE DUPLICATE KEY(`collecttime`, `source_id`) PARTITION BY (date_trunc(`collect_time`, 'DAY')) DISTRIBUTED BY RANDOM BUCKETS 2 PROPERTIES ( "replication_allocation" = "tag.location.default: 3", "min_load_replica_num" = "-1", "is_being_synced" = "false", "storage_medium" = "hdd", "storage_format" = "V2", "inverted_index_storage_format" = "V1", "light_schema_change" = "true", "disable_auto_compaction" = "false", "enable_single_replica_compaction" = "false", "group_commit_interval_ms" = "10000", "group_commit_data_bytes" = "134217728", "excluded_trigger_tables" = "base_muyun_service_log", "partition_sync_limit" = "365", "partition_sync_time_unit" = "DAY" ) AS SELECT date_trunc(`internal`.`cmdb_log`.`t1`.`collect_time`, 'minute') as `collecttime`, `internal`.`cmdb_log`.`t2`.`source_id`,`internal`.`cmdb_log`.`t2`.`scene_id`,`internal`.`cmdb_log`.`t2`.`system_id`,`internal`.`cmdb_log`.`t2`.`asset_id`, count(1) as `cnt` FROM `internal`.`cmdb_log`.`muyun_service_log` `t1` join `internal`.`cmdb_log`.`base_muyun_service_log` `t2` on `internal`.`cmdb_log`.`t1`.`asset_tag` = `internal`.`cmdb_log`.`t2`.`asset_tag` group by `internal`.`cmdb_log`.`t2`.`source_id`,`internal`.`cmdb_log`.`t2`.`scene_id`,`internal`.`cmdb_log`.`t2`.`system_id`,collecttime,`internal`.`cmdb_log`.`t2`.`asset_id`

执行以下sql后,物化视图实效/不更新

ALTER TABLE muyun_service_log_202512 REPLACE WITH TABLE muyun_service_log PROPERTIES('swap' = 'true');

请问是我使用问题吗,还是说要重建物化视图。如果我REPLACE WITH后,需要保留 muyun_service_log_202512 原有的物化视图数据,且muyun_service_log数据还会实时刷新,该怎么操作?

0 Answers