[SPARK-21630] Pmod should not throw a divide by zero exception

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 2.0.2, 2.1.1, 2.2.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Herman van Hövell
• Created: 03/Aug/17 20:39
• Updated: 04/Aug/17 07:54
• Resolved: 04/Aug/17 07:54

Description

Pmod currently throws a divide by zero exception when the right input is 0. It should - like Divide or Remainder - probably return null.

Here is a small reproducer:

scala> sql("select pmod(id, 0) from range(10)").show
17/08/03 22:36:43 ERROR Executor: Exception in task 0.0 in stage 3.0 (TID 3)
java.lang.ArithmeticException: / by zero

Issue Links

• is duplicated by: SPARK-21205 pmod(number, 0) should be null