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

        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
        Tony Stevenson made changes -
        Workflow no-reopen-closed, patch-avail, testing [ 12860344 ] Drill workflow [ 12933893 ]
        Jake Farrell made changes -
        Workflow no-reopen-closed, patch-avail [ 12807504 ] no-reopen-closed, patch-avail, testing [ 12860344 ]
        Jacques Nadeau made changes -
        Target Version/s M1 [ 12324669 ]
        Fix Version/s M1 [ 12324669 ]
        Jacques Nadeau made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Jake Farrell made changes -
        Workflow jira [ 12759247 ] no-reopen-closed, patch-avail [ 12807504 ]
        Timothy Chen made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Invalid [ 6 ]
        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 -
        Field Original Value New Value
        Assignee Timothy Chen [ tnachen ]
        Timothy Chen created issue -

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development