tianhui5 opened a new issue #7410: URL: https://github.com/apache/incubator-doris/issues/7410
### 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 When we create a materialization view with function like `concat`, and use `WITH ROLLUP` clause, we can get wrong answer that not identical to ROLLUP defination. `CREATE TABLE `table1` ( `siteid` int(11) NULL DEFAULT "10" COMMENT "", `citycode` int(11) NULL COMMENT "", `username` varchar(32) NULL DEFAULT "" COMMENT "", `pv` bigint(20) NULL DEFAULT "0" COMMENT "" ) ENGINE=OLAP DUPLICATE KEY(`siteid`, `citycode`) COMMENT "OLAP" DISTRIBUTED BY HASH(`siteid`) BUCKETS 1 PROPERTIES ( "replication_num" = "3", "in_memory" = "false", "storage_format" = "V2" );` `create view view_test1 as select siteid, citycode, concat(username, pv) as concat from table1;` `select siteid, citycode, concat from view_test1 group by rollup(siteid, citycode, concat);` ### What's Wrong? The result is not suit ROLLUP defination. ### What You Expected? It should return multi-level result like below.  ### How to Reproduce? _No response_ ### 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
