apache / apache/arrow

[R] Support inequality joins

Open
#29,841 1 comment 2 reactions 0 assignees View on GitHub
Component: R Priority: Critical Status: needs champion Type: enhancement
Dominant language
C++
Stars
17.1k
Forks
4.3k
Avg merge
3d 13h
Merged PRs (30d)
88

Description

dplyr 1.1 supports inequality conditions in joins. We should explore what we can support.

**Reporter**: [Neal Richardson](https://issues.apache.org/jira/browse/ARROW-14264) / @nealrichardson
#### Related issues:
- [[C++][Compute] Implement outer join with support for residual predicates](https://github.com/apache/arrow/issues/29281) (depends upon)

**Note**: *This issue was originally created as [ARROW-14264](https://issues.apache.org/jira/browse/ARROW-14264). Please see the [migration documentation](https://github.com/apache/arrow/issues/14542) for further details.*

Contributor guide

Open the contributing guide

Research direction

Read the dplyr 1.1 inequality-join behavior and the dependent C++ issue #29281 first. Use those references to determine which inequality conditions Apache Arrow should support and define completion around implementing and validating that agreed scope in the R interface.

Written by the indexing model from the issue text.

Assessment

Tech stack
cpp, r
Domain
data
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.