[SPARK-37148] Improve error messages under ANSI mode

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.3.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Allison Wang
• Created: 28/Oct/21 17:23
• Updated: 28/Oct/21 17:23

Description

Improve error messages when ANSI mode is enabled. Many exceptions thrown under ANSI mode can be disruptive to users. We should provide clear error messages with workarounds.

Sub-Tasks

• Improve error messages for arithmetic overflow under ANSI mode: Resolved
• Improve error messages for SQL functions and operators under ANSI mode: Resolved
• Improve error messages for casting under ANSI mode: Resolved