MrsZHui opened a new issue, #13174: URL: https://github.com/apache/doris/issues/13174
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues. ### Version 1.1.1 ### What's Wrong? 当我创建一个物化视图时(对应建表和物化视图可以复现)，be集群全部宕机。 最后发现是因为指标列是TEXT类型导致。 ### What You Expected? 期望使用不合理的创建物化视图不合理时候，机器可以不宕机，这个问题很严重 ### How to Reproduce? 复现流程 1、建表 2、导入数据 3、创建物化视图，以下是对应的语句 CREATE TABLE `test` ( `dt` date NOT NULL COMMENT "分区日期", `new_cid` varchar(100) NULL COMMENT "new_cid", `pv` text NULL COMMENT "浏览pv", `duration` double NULL COMMENT "", `start_cnt` text NULL COMMENT "" ) ENGINE=OLAP DUPLICATE KEY(`dt`, `new_cid`) COMMENT "OLAP" PARTITION BY RANGE(`dt`) ( PARTITION p20221006 VALUES [('2022-10-06'), ('2022-10-07'))) DISTRIBUTED BY HASH(`new_cid`) BUCKETS 8 PROPERTIES ( "in_memory" = "false", "storage_format" = "V2" ); create materialized view test_mv as select dt ,new_cid ,sum(cast(pv as int)) as pv ,sum(duration) as duration ,sum(cast(start_cnt as int)) as start_cnt from test group by dt,new_cid; ### Anything Else? _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
