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-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
