[
https://issues.apache.org/jira/browse/HIVE-1809?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Paul Butler updated HIVE-1809:
------------------------------
Attachment: HIVE-1809.patch
> 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
> Attachments: HIVE-1809.patch
>
>
> 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.
