laoma0911 opened a new issue, #12384: URL: https://github.com/apache/doris/issues/12384
### 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. ### Description - 业务背景：我们当前业务场景是通过元数据构建的指标维度体系，用户行为是通过勾选配置的指标和维度来发起查询。指标配置过程会考虑尽量复用底表，所以指标配置时会添加相应的过滤条件。 - 问题：添加过滤条件后，查询阶段拼接的SQL时如果将条件上移至聚合函数中使用if函数包装会导致不能命中roll up，为保障查询效率，原本能合并为同一条SQL的指标，现在需要拆分为多条，但并发加大，引擎耗时也加剧了。 - 期待扩展的能力：期望if函数中的条件命中roll up ### Use case - 1.降低SQL并发 - 2.提升roll up命中范围 ### Related issues _No response_ ### Are you willing to submit PR? - [ ] 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
