Numeric try_add/try_divide/try_subtract/try_multiply should throw error from their children

XMLWordPrintableJSON

    • Type: Sub-task
    • Resolution: Fixed
    • Priority: Major
    • 3.4.0
    • Affects Version/s: 3.4.0
    • Component/s: SQL
    • None

      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.

       

       

            Assignee:
            Gengliang Wang
            Reporter:
            Gengliang Wang
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: