[ARROW-14293] [Python] Basic Join functionality in PyArrow

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 8.0.0
• Component/s: Python
• Labels: Umbrella
• External issue URL: https://github.com/apache/arrow/issues/29868
• Assignee: Unassigned
• Reporter: Alessandro Molina
• Created: 12/Oct/21 08:26
• Updated: 11/Jan/23 08:38
• Resolved: 20/Apr/22 15:31

Description

We want to expose a Table.join and Dataset.join functionalities in PyArrow which can leverage our join feature from the ExecPlan to expose.

The Table.join can easily return a new Table, questions about what Dataset.join might return are more complex as it probably doesn't make much sense to return a new Dataset given that the result won't map to any files on disk

Sub-Tasks

• [Python] Minimal ExecPlan bindings to perform Table joins in pyarrow: Resolved
• [Python] Make joins able to receive Datasets as inputs: Resolved
• [Python] Make joins able to receive Tables as inputs: Resolved
• [Python] Make joins able to output a Table as result.: Resolved
• [Python] Make joins able to output a Dataset as a result: Resolved
• [Python] Make Joins able to execute the join operation: Resolved
• [Docs] Document joins in PyArrow: Resolved