stevqin opened a new issue, #36347: URL: https://github.com/apache/doris/issues/36347
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Description CREATE-ASYNC-MATERIALIZED-VIEW support filed comment lake this ```sql CREATE MATERIALIZED VIEW vw_retail_total BUILD IMMEDIATE REFRESH COMPLETE ON SCHEDULE EVERY 1 WEEK DISTRIBUTED BY RANDOM BUCKETS auto AS select billdate as biz_date, dj.store_code as store_code, dj.sku as sku, sku.product_name as product_name, sum(dj.retail_qty) as qty, sum(dj.actual_retail_amt) as amt from dwd_retail_order dj inner join dim_sku sku on dj.sku = sku.sku inner join dim_store store on dj.store_code = store.store_code group by billdate, dj.store_code, dj.sku, sku.product_name; comment on table vw_retail_total.biz_date is '业务日期'; comment on table vw_retail_total.store_code is '店仓代码'; comment on table vw_retail_total.sku is 'SKU'; comment on table vw_retail_total.product_name is '商品名称'; comment on table vw_retail_total.qty is '数量'; comment on table vw_retail_total.amt is '金额'; ``` ### Use case _No response_ ### Related issues _No response_ ### Are you willing to submit PR? - [X] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
