alamb commented on issue #4398: URL: https://github.com/apache/datafusion/issues/4398#issuecomment-2656452977
The current plan on main has no extra ProjectonExec:
```
(venv)
andrewlamb@Andrews-MacBook-Pro-2:~/Software/datafusion/benchmarks/data/tpch_sf1$
datafusion-cli
DataFusion CLI v45.0.0
> explain select l_orderkey from lineitem where l_extendedprice='2618.76';
+---------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------+
| plan_type | plan
|
+---------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------+
| logical_plan | Projection: lineitem.l_orderkey
|
| | Filter: CAST(lineitem.l_extendedprice AS Utf8) =
Utf8("2618.76")
|
| | TableScan: lineitem projection=[l_orderkey,
l_extendedprice], partial_filters=[CAST(lineitem.l_extendedprice AS Utf8) =
Utf8("2618.76")]
|
| physical_plan | CoalesceBatchesExec: target_batch_size=8192
|
| | FilterExec: CAST(l_extendedprice@1 AS Utf8) = 2618.76,
projection=[l_orderkey@0]
|
| | DataSourceExec: file_groups={16 groups:
[[Users/andrewlamb/Software/datafusion/benchmarks/data/tpch_sf1/lineitem/part-0.parquet:0..10685817],
[Users/andrewlamb/Software/datafusion/benchmarks/data/tpch_sf1/lineitem/part-0.parquet:10685817..10772989,
Users/andrewlamb/Software/datafusion/benchmarks/data/tpch_sf1/lineitem/part-1.parquet:0..10598645],
[Users/andrewlamb/Software/datafusion/benchmarks/data/tpch_sf1/lineitem/part-1.parquet:10598645..10751448,
Users/andrewlamb/Software/datafusion/benchmarks/data/tpch_sf1/lineitem/part-10.parquet:0..10533014],
[Users/andrewlamb/Software/datafusion/benchmarks/data/tpch_sf1/lineitem/part-10.parquet:10533014..10665365,
Users/andrewlamb/Software/datafusion/benchmarks/data/tpch_sf1/lineitem/part-11.parquet:0..10553466],
[Users/andrewlamb/Software/datafusion/benchmarks/data/tpch_sf1/lineitem/part-11.parquet:10553466..10663428,
Users/andrewlamb/Software/datafusion/benchmarks/data/tpch_sf1/lineitem/part-12.parquet:0..10575855]
, ...]}, projection=[l_orderkey, l_extendedprice], file_type=parquet,
predicate=CAST(l_extendedprice@5 AS Utf8) = 2618.76 |
| |
|
+---------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------+
2 row(s) fetched.
Elapsed 0.015 seconds.
```
--
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]
