jayzhan211 commented on issue #10935: URL: https://github.com/apache/datafusion/issues/10935#issuecomment-2172572734
@ahirner I found an alternative query is to move filter into the query `select "unnest(v.column2)" from (select unnest(column2), column1 from v where column1=2);` ``` query TT explain select "unnest(v.column2)" from (select unnest(column2), column1 from v where column1=2); ---- logical_plan 01)Projection: unnest(v.column2) 02)--Unnest: lists[unnest(v.column2)] structs[] 03)----Projection: v.column2 AS unnest(v.column2), v.column1 04)------Filter: v.column1 = Int64(2) 05)--------TableScan: v projection=[column1, column2] physical_plan 01)ProjectionExec: expr=[unnest(v.column2)@0 as unnest(v.column2)] 02)--UnnestExec 03)----RepartitionExec: partitioning=RoundRobinBatch(4), input_partitions=1 04)------ProjectionExec: expr=[column2@1 as unnest(v.column2), column1@0 as column1] 05)--------CoalesceBatchesExec: target_batch_size=8192 06)----------FilterExec: column1@0 = 2 07)------------MemoryExec: partitions=1, partition_sizes=[1] ``` Given that, it might not be neccessary to support pushing down **outer** filter -- 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
