[SPARK-42278] DS V2 pushdown supports supports JDBC dialects compile `SortOrder` by themselves

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.4.0
• Fix Version/s: 3.4.0
• Component/s: SQL
• Assignee: Jiaan Geng
• Reporter: Jiaan Geng
• Created: 01/Feb/23 08:49
• Updated: 01/Feb/23 12:18
• Resolved: 01/Feb/23 12:18

Description

Currently, DS V2 pushdown framework compile the SortOrder in fixed format.
This is not flexible and friendly for some databases that do not support this syntax.
For example, the fixed format order by col asc nulls first is not supported by mssql server who doesn't support nulls first.

Issue Links

• links to: [Github] Pull Request #39846 (beliefer)
• links to: [Github] Pull Request #39846 (beliefer)