irenjj commented on issue #5492: URL: https://github.com/apache/datafusion/issues/5492#issuecomment-2889002891
> I recommend we also do some research on existing systems. Can someone provide links to existing implementations in other systems? > > * DuckDB > * Spark > * Apache Calcite ( Maybe [@suibianwanwank](https://github.com/suibianwanwank) can help, as they have significant experience with this part of calcite's optimizer in this area -- https://github.com/apache/calcite/issues?q=is%3Apr+is%3Aopen+author%3Asuibianwanwank) For DuckDB: basic logic is in `plan_subquery.cpp` file(can't find a specific pr) https://github.com/duckdb/duckdb/blob/main/src/planner/binder/query_node/plan_subquery.cpp, For "Unnesting Arbitrary Subqueries," there is a complete implementation. And 2nd paper implementation: https://github.com/duckdb/duckdb/pull/17294 -- 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-unsubscr...@datafusion.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For additional commands, e-mail: github-h...@datafusion.apache.org
