You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by GitBox <gi...@apache.org> on 2022/10/15 13:27:47 UTC
[GitHub] [arrow-datafusion] Dandandan opened a new issue, #3839: Filter pushdown doesn't seem to apply for filter on TPC-H Q17
Dandandan opened a new issue, #3839:
URL: https://github.com/apache/arrow-datafusion/issues/3839
**Is your feature request related to a problem or challenge? Please describe what you are trying to do.**
For q17 this is the optimized plan.
```
Projection: CAST(SUM(lineitem.l_extendedprice) AS Decimal128(38, 33)) / Decimal128(Some(7000000000000000195487369212723200),38,33) AS avg_yearly
Aggregate: groupBy=[[]], aggr=[[SUM(lineitem.l_extendedprice)]]
Filter: CAST(lineitem.l_quantity AS Decimal128(38, 21)) < __sq_1.__value
Inner Join: part.p_partkey = __sq_1.l_partkey
Inner Join: lineitem.l_partkey = part.p_partkey
TableScan: lineitem projection=[l_partkey, l_quantity, l_extendedprice]
Filter: part.p_brand = Utf8("Brand#23") AND part.p_container = Utf8("MED BOX")
TableScan: part projection=[p_partkey, p_brand, p_container]
Projection: lineitem.l_partkey, Decimal128(Some(200000000000000000000),38,21) * CAST(AVG(lineitem.l_quantity) AS Decimal128(38, 21)) AS __value, alias=__sq_1
Aggregate: groupBy=[[lineitem.l_partkey]], aggr=[[AVG(lineitem.l_quantity)]]
TableScan: lineitem projection=[l_partkey, l_quantity, l_extendedprice]
```
Looking at the filter `CAST(lineitem.l_quantity AS Decimal128(38, 21)) < __sq_1.__value` it seems this one can be pushed down one level below the join, as all fields are available before the join and it is an inner join.
**Describe the solution you'd like**
Fix filter pushdown for this case.
**Describe alternatives you've considered**
**Additional context**
--
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: github-unsubscribe@arrow.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] Dandandan closed issue #3839: Filter pushdown doesn't seem to apply for filter on TPC-H Q17
Posted by GitBox <gi...@apache.org>.
Dandandan closed issue #3839: Filter pushdown doesn't seem to apply for filter on TPC-H Q17
URL: https://github.com/apache/arrow-datafusion/issues/3839
--
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: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] Dandandan commented on issue #3839: Filter pushdown doesn't seem to apply for filter on TPC-H Q17
Posted by GitBox <gi...@apache.org>.
Dandandan commented on issue #3839:
URL: https://github.com/apache/arrow-datafusion/issues/3839#issuecomment-1279815109
My suggestion was Incorrect - moving it one level below is not possible.
--
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: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org