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

      , ...

      ]

      }

        Activity

        Timothy Chen created issue -
        Timothy Chen made changes -
        Field Original Value New Value
        Assignee Timothy Chen [ tnachen ]
        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.
        Timothy Chen made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Invalid [ 6 ]
        Jake Farrell made changes -
        Workflow jira [ 12759247 ] no-reopen-closed, patch-avail [ 12807504 ]
        Jacques Nadeau made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Jacques Nadeau made changes -
        Target Version/s M1 [ 12324669 ]
        Fix Version/s M1 [ 12324669 ]
        Jake Farrell made changes -
        Workflow no-reopen-closed, patch-avail [ 12807504 ] no-reopen-closed, patch-avail, testing [ 12860344 ]
        Tony Stevenson made changes -
        Workflow no-reopen-closed, patch-avail, testing [ 12860344 ] Drill workflow [ 12933893 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Resolved Resolved
        3d 18h 4m 1 Timothy Chen 05/Feb/13 00:38
        Resolved Resolved Closed Closed
        246d 17h 27m 1 Jacques Nadeau 09/Oct/13 19:05

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development