[SPARK-19994] Wrong outputOrdering for right/full outer smj

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.2, 2.1.0, 2.2.0
• Fix Version/s: 2.0.3, 2.1.1, 2.2.0
• Component/s: SQL
• Labels: correctness
• Target Version/s: 2.1.1, 2.2.0
• Assignee: Zhenhua Wang
• Reporter: Zhenhua Wang
• Created: 17/Mar/17 07:06
• Updated: 21/Mar/17 10:41
• Resolved: 20/Mar/17 06:39

Description

For right outer join, values of the left key will be filled with nulls if it can't match the value of the right key, so `nullOrdering` of the left key can't be guaranteed. We should output right key order.

For full outer join, neither left key nor right key guarantees `nullOrdering`. We should not output any ordering.

Issue Links

• links to: [Github] Pull Request #17331 (wzhfy)
• links to: [Github] Pull Request #17376 (wzhfy)