[IMPALA-498] Hit NullPointerException when perform modulus (%) between non-integer number

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 1.0.1
• Fix Version/s: Impala 1.2
• Labels: impala
• Environment: Hadoop 2.0.0-cdh4.3.0
• Assignee: Alexander Behm
• Reporter: Kuek Chiew Yea
• Created: 31/Jul/13 02:25
• Updated: 20/Dec/15 00:05
• Resolved: 15/Sep/13 05:12

Description

When performed the following query which include the modulus operator in impala, it will hit NullPointerException:

[MYRNDSVRVM311:21000] > select (3.55 % 2) from city;
Query: select (3.55 % 2) from city
ERROR: AnalysisException: null
CAUSED BY: NullPointerException: null
[MYRNDSVRVM311:21000] > select (3 % 2) from city limit 1;
Query: select (3 % 2) from city limit 1
Query finished, fetching results ...
-------

3 % 2

-------

1

-------
Returned 1 row(s) in 0.55s
[MYRNDSVRVM311:21000] >

When performed the same query in hive, everything works well. Impala query only works fine when we try to use modulus (%) between two integer.