[jira] Commented: (HIVE-1809) Hive comparison operators are broken for NaN values

["Ning Zhang (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-1809?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12935161#action_12935161 ] 

Ning Zhang commented on HIVE-1809:
----------------------------------

+1. start testing. 

> 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.