Hive comparison operators are broken for NaN values
---------------------------------------------------
Key: HIVE-1809
URL: https://issues.apache.org/jira/browse/HIVE-1809
Project: Hive
Issue Type: Bug
Reporter: Paul Butler
Assignee: Paul Butler
Comparisons between NaN values and doubles do not work as expected:
hive> select 'NaN' = 4.3 from data_one limit 1;
Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Execution log at:
/tmp/pbutler/pbutler_20101123145656_d23f9b77-8907-4ed3-aef9-8b99a1cc3138.log
Job running in-process (local Hadoop)
2010-11-23 14:56:40,488 null map = 100%, reduce = 0%
Ended Job = job_local_0001
OK
true
Time taken: 9.47 seconds
hive> select 4 <> 'NaN' from data_one limit 1;
Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Execution log at:
/tmp/pbutler/pbutler_20101123145858_0d243ac2-f745-4e25-9a38-509bef3bb370.log
Job running in-process (local Hadoop)
2010-11-23 14:58:45,689 null map = 100%, reduce = 0%
Ended Job = job_local_0001
OK
false
Time taken: 3.938 seconds
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
