[SPARK-37287] Pull out dynamic partition and bucket sort from FileFormatWriter

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.3.0
• Fix Version/s: 3.4.0
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Allison Wang
• Reporter: XiDuo You
• Created: 11/Nov/21 09:57
• Updated: 13/Nov/23 02:20
• Resolved: 19/Jul/22 13:31

Description

`FileFormatWriter.write` now is used by all V1 write which includes datasource and hive table. However it contains a sort which is based on dynamic partition and bucket columns that can not be seen in plan directly.

V2 write has a better approach that it satisfies the order or even distribution by using rule `V2Writes`.

V1 write should do the similar thing with V2 write.

 

Issue Links

• causes: SPARK-44512 dataset.sort.select.write.partitionBy sorts wrong column
• links to: [Github] Pull Request #34568 (ulysses-you)
• links to: [Github] Pull Request #37099 (allisonwang-db)
• links to: [Github] Pull Request #37308 (allisonwang-db)
• links to: [Github] Pull Request #37308 (allisonwang-db)
• links to: GitHub Pull Request #37099