Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-25

Implement AntiJoin Reference Operator

    Details

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

      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>}

      , ...

      ]

      }

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: