Re: [I] [Bug] orca: Inner Hashjoin failed with Partition selector [cloudberry]

["fanfuxiaoran (via GitHub)" <gi...@apache.org>]

fanfuxiaoran commented on issue #854:
URL: https://github.com/apache/cloudberry/issues/854#issuecomment-2705833696

    Further dived into the code,  know more that why orca cannot generate the plan:
   - as explained above, when there is a motion in the plan,  the property 'partition propagation:  consumer' cannot be satisfied, as the. (partition selector and consumer must use the shared memory to send the data, so they must be in the same process)
   - another reason is when hashjoin is used, and there is only one `ulOptReq` on the top, the `partition propagation:  consumer` (partition  property) will be required from children, if the property cannot be satisfied, no plan will be generated.
   the related code is in function `CPhysicalHashJoin::PppsRequiredForJoins`


-- 
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: commits-unsubscribe@cloudberry.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: commits-help@cloudberry.apache.org