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

Implement AntiJoin Reference Operator

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Invalid
    • None
    • 0.1.0-m1
    • None

    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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment