You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "Silun Dong (Jira)" <ji...@apache.org> on 2025/12/05 06:21:00 UTC

[jira] [Created] (CALCITE-7315) Support LEFT_MARK type for hash join in enumerable convention

Silun Dong created CALCITE-7315:
-----------------------------------

             Summary: Support LEFT_MARK type for hash join in enumerable convention
                 Key: CALCITE-7315
                 URL: https://issues.apache.org/jira/browse/CALCITE-7315
             Project: Calcite
          Issue Type: Improvement
          Components: core, linq4j
            Reporter: Silun Dong
            Assignee: Silun Dong


In CALCITE-7031, we introduce a new join type: LEFT MARK, and left a TODO about implementing the LEFT MARK JOIN in the enumerable convention.

An LEFT MARK JOIN will keep all rows from the left side and creates a new attribute to mark a tuple as having join partners from right side or not. LEFT MARK JOIN is typically generated by rewriting SOME/EXISTS/IN subqueries. 

This ticket will add support for the LEFT MARK type to the hash join.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)