[SPARK-38196] Reactor framework so as JDBC dialect could compile expression by self way

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.3.0
• Fix Version/s: 3.3.0
• Component/s: SQL
• Assignee: Jiaan Geng
• Reporter: Jiaan Geng
• Created: 14/Feb/22 01:47
• Updated: 11/Apr/22 06:59
• Resolved: 04/Mar/22 13:24

Description

https://issues.apache.org/jira/browse/SPARK-37960 provides a new framework to represent catalyst expressions in DS V2 APIs.
Because the framework translate all catalyst expressions to a unified SQL string and cannot keep compatibility between different JDBC database, the framework works not good.

This PR reactor the framework so as JDBC dialect could compile expression by self way.
First, The framework translate catalyst expressions to DS V2 expression.
Second, The JDBC dialect could compile DS V2 expression to different SQL syntax.

Issue Links

• links to: [Github] Pull Request #35494 (beliefer)
• links to: [Github] Pull Request #35818 (cloud-fan)