[SPARK-41456] Improve the performance of try_cast

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.4.0
• Fix Version/s: 3.4.0
• Component/s: SQL
• Assignee: Gengliang Wang
• Reporter: Gengliang Wang
• Created: 09/Dec/22 05:14
• Updated: 09/Dec/22 23:50
• Resolved: 09/Dec/22 23:50

Description

For try_cast and the legacy cast (cast with ANSI SQL mode off), there are conversion which has the same behaviors:

• cast(string as date/timestamp/TimestampNTZ)
• cast(string as double/float/decimal)

So, the try_cast can be faster if it uses the evaluation code path of the legacy cast, instead of turning into ANSI cast and catching exceptions.

Issue Links

• links to: [Github] Pull Request #38988 (gengliangwang)