[SPARK-49634] Remove the ANSI config suggestion in NUMERIC_VALUE_OUT_OF_RANGE.WITH_SUGGESTION

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 4.0.0
• Component/s: SQL
• Labels: starter
• Epic Link: ANSI by default
• Assignee: Unassigned
• Reporter: Mihailo Milosevic
• Created: 13/Sep/24 10:19
• Updated: 13/Sep/24 10:20

Description

NUMERIC_VALUE_OUT_OF_RANGE.WITH_SUGGESTION contains suggested fix for turning off ANSI mode. Now that in Spark 4.0.0 we have moved to ANSI mode on by default, we want to keep suggestions of this kind to the minimum. There exist implementations of `try_*` functions which provide safe way to get behaviour as for ANSI mode off and suggestions of this kind should be sufficient.