haohuaijin commented on issue #25244:
URL: https://github.com/apache/datafusion/issues/25244#issuecomment-5652696898
i can use sql to reproduce
```sql
SET datafusion.execution.target_partitions = 1;
SET datafusion.execution.collect_statistics = true;
SET datafusion.execution.parquet.schema_force_view_types = false;
SET datafusion.optimizer.join_reordering = false;
COPY (SELECT 'a1' AS id, 'x1' AS ty)
TO '/tmp/df25244_single_a.parquet'
STORED AS PARQUET;
COPY (SELECT 'x1' AS id)
TO '/tmp/df25244_single_b.parquet'
STORED AS PARQUET;
CREATE EXTERNAL TABLE ta
STORED AS PARQUET
LOCATION '/tmp/df25244_single_a.parquet';
CREATE EXTERNAL TABLE tb
STORED AS PARQUET
LOCATION '/tmp/df25244_single_b.parquet';
-- disable dynamic filter
SET datafusion.optimizer.enable_join_dynamic_filter_pushdown = false;
SELECT s.id AS sid, a.id AS aid, b.id AS bid, c.id AS cid
FROM tb s
JOIN (
(ta a LEFT JOIN tb b ON a.ty = b.id)
LEFT JOIN tb c ON b.id = c.id
)
ON s.id = b.id;
-- enable dynamic filter
SET datafusion.optimizer.enable_join_dynamic_filter_pushdown = true;
SELECT s.id AS sid, a.id AS aid, b.id AS bid, c.id AS cid
FROM tb s
JOIN (
(ta a LEFT JOIN tb b ON a.ty = b.id)
LEFT JOIN tb c ON b.id = c.id
)
ON s.id = b.id;
```
--
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]
