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 00:58:00 UTC

[jira] [Closed] (IMPALA-3267) Docs about nan/inf are incorrect

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

Alex Rodoni closed IMPALA-3267.
-------------------------------
       Resolution: Fixed
    Fix Version/s: Impala 2.11.0

> Docs about nan/inf are incorrect
> --------------------------------
>
>                 Key: IMPALA-3267
>                 URL: https://issues.apache.org/jira/browse/IMPALA-3267
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Docs
>    Affects Versions: Impala 2.2
>            Reporter: Todd Lipcon
>            Assignee: Alex Rodoni
>            Priority: Trivial
>             Fix For: Impala 2.11.0
>
>
> The docs say:
> "Infinity and NaN can be specified in text data files as inf and nan respectively, and Impala interprets them as these special values. They can also be produced by certain arithmetic expressions; for example, pow(-1, 0.5) returns infinity and 1/0 returns NaN. Or you can cast the literal values, such as CAST('nan' AS DOUBLE) or CAST('inf' AS DOUBLE)."
> but the examples are backwards - sqrt(-1) is NaN and 1/0 is inf.



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