You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@impala.apache.org by "Alex Rodoni (JIRA)" <ji...@apache.org> on 2018/05/07 01:01:00 UTC

[jira] [Closed] (IMPALA-3603) Document handling of NaN values

     [ https://issues.apache.org/jira/browse/IMPALA-3603?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Alex Rodoni closed IMPALA-3603.
-------------------------------
       Resolution: Fixed
    Fix Version/s: impala 2.3

> Document handling of NaN values
> -------------------------------
>
>                 Key: IMPALA-3603
>                 URL: https://issues.apache.org/jira/browse/IMPALA-3603
>             Project: IMPALA
>          Issue Type: Improvement
>          Components: Docs
>    Affects Versions: Impala 2.2.4
>            Reporter: Will Berkeley
>            Assignee: Alex Rodoni
>            Priority: Minor
>             Fix For: impala 2.3
>
>
> Impala appears to handle NaN values according to IEEE 754:
> {code}
> select CAST('nan' as DOUBLE) = CAST('nan' as DOUBLE);
> false
> {code}
> This should be noted in the docs about FLOAT and DOUBLE type, especially because [Postgres handles NaN differently|http://www.postgresql.org/docs/8.4/static/datatype-numeric.html]: NaN == NaN and NaN > inf for indexing purposes.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)