[SPARK-30292] Throw Exception when invalid string is cast to decimal in ANSI mode

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: SQL
• Assignee: Rakesh Raushan
• Reporter: Rakesh Raushan
• Created: 18/Dec/19 06:24
• Updated: 05/Apr/23 16:22
• Resolved: 14/Jan/20 09:04

Description

When spark.sql.ansi.enabled is set,

If we run select cast('str' as decimal), spark-sql outputs NULL. 

The ANSI SQL standard requires to throw exception when invalid strings are cast to numbers.

 

Issue Links

• is duplicated by: SPARK-30472 [SQL] ANSI SQL: Throw exception on format invalid and overflow when casting String to IntegerType.
• links to: GitHub Pull Request #26933
• links to: GitHub Pull Request #27957