Apache Drill
  1. Apache Drill
  2. DRILL-25

Implement AntiJoin Reference Operator

    Details

    • Type: New Feature New Feature
    • Status: Closed
    • Priority: Major Major
    • Resolution: Invalid
    • Affects Version/s: None
    • Fix Version/s: m1
    • Component/s: None
    • Labels:
    • Target Version/s:
      m1

      Description

      AntiJoin (M)

      The antijoin operator works similarly to the filter operator. However, the exclusion or inclusion of a particular record is based on whether or not there is a match in the mask record stream. If a match is found in the mask record stream based on the provided conditions, the input record is excluded from output. In the case that no match is found within the mask stream, the input record is passed through untouched.
      { @id†: <opref>, op: “antijoin”,

      input: <input>,

      mask: <input>,

      conditions: [

      {relationship: <reltype>, left: <expr>, right: <expr>}

      , ...

      ]

      }

        Activity

        Hide
        Timothy Chen added a comment -

        After discussing with Jacques, this operator will be merged into Join operator and not needing a separate operator.

        Show
        Timothy Chen added a comment - After discussing with Jacques, this operator will be merged into Join operator and not needing a separate operator.

          People

          • Assignee:
            Timothy Chen
            Reporter:
            Timothy Chen
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development