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

["Gengliang Wang (Jira)" <ji...@apache.org>]

Gengliang Wang created SPARK-40222:
--------------------------------------

             Summary: Numeric try_add/try_divide/try_subtract/try_multiply should throw error from their children
                 Key: SPARK-40222
                 URL: https://issues.apache.org/jira/browse/SPARK-40222
             Project: Spark
          Issue Type: Sub-task
          Components: SQL
    Affects Versions: 3.4.0
            Reporter: Gengliang Wang
            Assignee: Gengliang Wang


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|https://github.com/databricks/runtime/blob/master/sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/analysis/Analyzer.scala#L501] 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.

 

 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org