[SPARK-40222] Numeric try_add/try_divide/try_subtract/try_multiply should throw error from their children

• Type: Sub-task
• 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: 25/Aug/22 22:27
• Updated: 26/Aug/22 21:19
• Resolved: 26/Aug/22 21:19

Description

Similar to https://issues.apache.org/jira/browse/SPARK-40054, we should refactor the try_add/try_subtract/try_multiply/try_divide functions so that the errors from their children will be shown instead of ignored.
 Spark SQL allows arithmetic operations between Number/Date/Timestamp/CalendarInterval/AnsiInterval (see the rule ResolveBinaryArithmetic for details). Some of these combinations can throw exceptions too: * Date + CalendarInterval

• Date + AnsiInterval
• Timestamp + AnsiInterval
• Date - CalendarInterval
• Date - AnsiInterval
• Timestamp - AnsiInterval
• Number * CalendarInterval
• Number * AnsiInterval
• CalendarInterval / Number
• AnsiInterval / Number

This Jira is for the cases when both input data types are numbers.

 

 

Issue Links

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