You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2022/09/06 08:40:40 UTC
[GitHub] [doris] laoma0911 opened a new issue, #12384: [Feature] if函数中的条件命中roll up
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-unsubscribe@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Feature] if函数中的条件命中roll up [doris]
Posted by "laoma0911 (via GitHub)" <gi...@apache.org>.
laoma0911 commented on issue #12384:
URL: https://github.com/apache/doris/issues/12384#issuecomment-3294552622
这是来自QQ邮箱的假期自动回复邮件。
您好，我最近正在休假中，无法亲自回复您的邮件。我将在假期结束后，尽快给您回复。
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] laoma0911 commented on issue #12384: [Feature] if函数中的条件命中roll up
Posted by GitBox <gi...@apache.org>.
laoma0911 commented on issue #12384:
URL: https://github.com/apache/doris/issues/12384#issuecomment-1239616785
这是来自QQ邮箱的假期自动回复邮件。
您好，我最近正在休假中，无法亲自回复您的邮件。我将在假期结束后，尽快给您回复。
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] dataalive commented on issue #12384: [Feature] if函数中的条件命中roll up
Posted by GitBox <gi...@apache.org>.
dataalive commented on issue #12384:
URL: https://github.com/apache/doris/issues/12384#issuecomment-1239616469
能不能来个示例的schema 和 简化的SQL
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Feature] if函数中的条件命中roll up [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman closed issue #12384: [Feature] if函数中的条件命中roll up
URL: https://github.com/apache/doris/issues/12384
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org