hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paul Butler (JIRA)" <j...@apache.org>
Subject [jira] Updated: (HIVE-1809) Hive comparison operators are broken for NaN values
Date Tue, 23 Nov 2010 23:02:19 GMT

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


Mime
View raw message