goldmedal commented on issue #13659: URL: https://github.com/apache/datafusion/issues/13659#issuecomment-2520565398
> This should be a LATERAL JOIN, with the LATERAL keyword omitted. We do not support it yet. #10048 > > As stated in the PostgreSQL [documentation](https://www.postgresql.org/docs/current/queries-table-expressions.html#QUERIES-LATERAL). > > > Table functions appearing in FROM can also be preceded by the key word LATERAL, but for functions the key word is optional; Thanks for the information. Indeed, this is an implicit LATERAL join. I tried to use explicit LATERAL for it (I think they are equal 🤔 ) like ``` select * from t1, LATERAL (select unnest(t1.c1)) ``` and get the error: ``` Error: This feature is not implemented: Physical plan does not support logical expression OuterReferenceColumn(List(Field { name: "item", data_type: Int32, nullable: true, dict_id: 0, dict_is_ordered: false, metadata: {} }), Column { relation: Some(Bare { table: "t1" }), name: "c1" }) backtrace: 0: std::backtrace_rs::backtrace::libunwind::trace at /rustc/90b35a6239c3d8bdabc530a6a0816f7ff89a0aaf/library/std/src/../../backtrace/src/backtrace/libunwind.rs:116:5 1: std::backtrace_rs::backtrace::trace_unsynchronized at /rustc/90b35a6239c3d8bdabc530a6a0816f7ff89a0aaf/library/std/src/../../backtrace/src/backtrace/mod.rs:66:5 2: std::backtrace::Backtrace::create at /rustc/90b35a6239c3d8bdabc530a6a0816f7ff89a0aaf/library/std/src/backtrace.rs:331:13 3: std::backtrace::Backtrace::capture at /rustc/90b35a6239c3d8bdabc530a6a0816f7ff89a0aaf/library/std/src/backtrace.rs:296:9 4: datafusion_common::error::DataFusionError::get_back_trace at ./datafusion/common/src/error.rs:398:30 5: datafusion_physical_expr::planner::create_physical_expr at ./datafusion/physical-expr/src/planner.rs:365:13 6: datafusion_physical_expr::planner::create_physical_expr at ./datafusion/physical-expr/src/planner.rs:115:16 ``` It seems that the physical plan isn't ready 🤔 I think there are two issues: - Plan the implicit LATERAL for unnest - Support the physical plan for LATERAL JOIN -- 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
