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