[SPARK-47386] Ability to only take first match for join when there are miltiple match

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 3.5.1
• Component/s: Spark Core, SQL
• Labels: SQL SparkSQL
• Assignee: Unassigned
• Reporter: Vijay Jangir
• Created: 14/Mar/24 03:37
• Updated: 14/Mar/24 03:41

Description

When joining 2 datasets, it can be desirable to only get first matching row instead of all. This can be helpful when the right table has fuplicates, and dropping duplicate is not desired due to data volume.