pjmore removed a comment on issue #1293:
URL:
https://github.com/apache/arrow-datafusion/issues/1293#issuecomment-980834687
This looks like the same issue that affects the performance of TPCH 9. Using
the example from @houqp and the solution I outlined in #77 gives:
```
❯ create table part as select 1 as p_partkey;
0 rows in set. Query took 0.001 seconds.
❯ create table lineitem as select 1 as l_partkey, 2 as l_suppkey;
0 rows in set. Query took 0.000 seconds.
❯ create table supplier as select 1 as s_suppkey;
0 rows in set. Query took 0.000 seconds.
❯ explain select * from part, supplier, lineitem where p_partkey = l_partkey
and s_suppkey = l_suppkey;
+---------------+----------------------------------------------------------------------------------------------------------------------------------------------------+
| plan_type | plan
|
+---------------+----------------------------------------------------------------------------------------------------------------------------------------------------+
| logical_plan | Projection: #part.p_partkey, #lineitem.l_partkey,
#lineitem.l_suppkey, #supplier.s_suppkey
|
| | Join: #lineitem.l_suppkey = #supplier.s_suppkey
|
| | Join: #part.p_partkey = #lineitem.l_partkey
|
| | TableScan: part projection=Some([0])
|
| | TableScan: lineitem projection=Some([0, 1])
|
| | TableScan: supplier projection=Some([0])
```
--
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]
