[SPARK-39835] Fix EliminateSorts remove global sort below the local sort

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.4.0
• Fix Version/s: 3.1.4, 3.3.1, 3.2.3, 3.4.0
• Component/s: SQL
• Assignee: XiDuo You
• Reporter: XiDuo You
• Created: 22/Jul/22 03:17
• Updated: 03/Aug/22 03:16
• Resolved: 25/Jul/22 10:35

Description

If a global sort below locol sort, we should not remove the global sort becuase the output partitioning can be affected.

This issue is going to worse since we pull out the V1 Write sort to logcial side.

Issue Links

• links to: [Github] Pull Request #37250 (ulysses-you)
• links to: [Github] Pull Request #37275 (ulysses-you)
• links to: [Github] Pull Request #37276 (ulysses-you)