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/05/31 08:46:15 UTC
[GitHub] [incubator-doris] jackwener opened a new issue, #9884: [Bug] Predicate Pushdown is incomplete
jackwener opened a new issue, #9884:
URL: https://github.com/apache/incubator-doris/issues/9884
### 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
`master`
### What's Wrong?
```sql
explain
with cte as
(
select name, `day`, `hour`, time_zone,
BITMAP_UNION_COUNT(userid_bitmap) over (PARTITION by day order by hour) active_unt_mtd
from
(
select hour, name, `day`, time_zone, bitmap_union(userid_bitmap) userid_bitmap
from table_one_day
group by 1,2,3,4,5,
) final
)
select * from cte where name='mus' and day = '2021-12-01';
```
Predicate `where name='mus' and day = '2021-12-01'`, just pushdown `day = '2021-12-01'`.
Because judge predicate is according `PARTITION by` (it's `CommonPartitionExprs` in the code)
### What You Expected?
Push all predicate as much as possible.
### 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: 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
[GitHub] [incubator-doris] jackwener closed issue #9884: [Bug] Predicate Pushdown is incomplete
Posted by GitBox <gi...@apache.org>.
jackwener closed issue #9884: [Bug] Predicate Pushdown is incomplete
URL: https://github.com/apache/incubator-doris/issues/9884
--
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] [incubator-doris] jackwener commented on issue #9884: [Bug] Predicate Pushdown is incomplete
Posted by GitBox <gi...@apache.org>.
jackwener commented on issue #9884:
URL: https://github.com/apache/incubator-doris/issues/9884#issuecomment-1147068088
It shouldn't be pushdown
--
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